Using SUMIF to sum multiple criteria

By Neil Shorney, 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.