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.
