Doing the “total spend this year”, “total spend this month” shuffle using SumIFS

Published: Fri, 09/26/14

The Excel Expert

Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users

Doing the “total spend this year”, “total spend this month” shuffle using SumIFS- 2014-09-23 10:48:26-04

Recently I went in to do some training with a new manager who had been tearing his hair out with his Excel sheet. The spreadsheet had already been set up for him and the previous incumbent had done some interesting array formula variations using If and Sum – and it worked fine actually. The only [...]
Read more...