Excel Tips Monster

Two dimensional SUMIF

Chandoo wrote a quick tip about using SUMIF on two-dimensional ranges.

As useful as this seems, note that in his example there are several columns for sales people, by month (columns G through J).

This trick would not work if your criteria data is one-dimensional and the data to be summed is two-dimensional (e.g. one column for sales person name, and 12 columns for income per month)

The simple solution in such a case, however, is to add another column that will hold each row’s SUM, and do the SUMIF on that column against the name column.

So it’s not a real problem after all