Wednesday, May 1, 2013


As you may know by now, I am a big proponent of using Interactive Reports. Reports of this nature can be made with a variety of innate Excel tools, including DFunctions, Sumproduct, Vlookup, etc.

There is one Typically Overlooked function for making interactive reports, however. The SUMIFS, (Note the plural), is a surprisingly powerful tool for this purpose.

First of all, the Syntax for SUMIFS:

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Unlike its close cousin, SUMIF, the SUMIFS function allows you to conditionally Sum values with Multiple Conditions, rather than just one.

For instance, let’s say you have a table/database that has multiple entries of Sales for Months and Weeks. Using a SUMIFS formula, along with dropdown boxes for the Month and Week, you can make an Interactive Report that is contingent on the parameters you choose.

Bottom Line: If you have ever used the Little Cousin, SUMIF, and wanted more flexibility, you owe it to yourself to try out the vastly more powerful SUMIFS.

As I have said before, Interactive Reports – They are so easy, They'll Make You Smile!

No comments: