We all know that SUMIF formula can be used to find the sum of values meeting a criteria. Like this,
But I was pleasantly surprised to realize that SUMIF works equally well for 2D ranges too, like this:
During a recent consulting work with a client I had a requirement to sum up values that meet some criteria across columns and I wasn’t sure if the SUMIF would hold. Boy, I was wrong. It worked nicely and I still stand by my statement “If I get a dollar for every COUNTIF / SUMIF I write, I will have million dollar bills.“.
Did you try 2D SUMIF?
Share your tips and ideas thru comments.
Bonus: This should work for COUNTIF, SUMIFS, COUNTIFS etc too. But you already knew it.