Wednesday, May 1, 2013
SUMIFS (Not Just SUMIF)!
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!