Wednesday, 14 May 2014

Using SUMIF to sum multiple criteria

By , Director, Naturally Sales Ltd.


Last time we looked at the COUNTIFS function. This time, we take it a stage further to look at SUMIFS.
 

Just adding an “S” and making it SUMIFS allows us to sum multiple criteria. It works like this:

=SUMIFS(sum_range_1, criteria_range_1, criteria_1, criteria_range_2, criteria_2, …)

There is, however, a limitation, which is that you can’t refer to other workbooks unless they’re open at the time. For this, you’d need the SUMPRODUCT function, which is one of my favourites.

No comments:

Post a comment