Simon Hurst unearths and highlights some of the most commonly recurring themes from Excel Zone’s Any Answers.
Introduction
functions
Individual functions, such as sales marketing, operations and the supply chain, can contribute to the overall objective, explains Rod Newing.
1
Last month, David H Ringstrom discussed ways in which Excel formulae using SUM functions could be extended by using multiple criteria.
5
AccountingWEB.com contributor David H. Ringstrom CPA recently published a collection of useful tips on how popular formulae can be extended by using multiple criteria.
1
In another selection from his series of tutorials on AccountingWEB.com, David Ringstrom illuminates the uses of Excel’s FREQUENCY function.
Practical applications for SUMIF and IF functionsExcel provides a handy fuction which calculates the number of working days (or weekdays such as Mon, Tue, Wed, Thu, Fri) between 2 dates. You can adapt it to take account of bank holidays.
