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.
One Response to “How to export YouTube video comments to Excel file? – Free template + Power Query case study”
And I asked myself when i saw your Accouncement Video for the Give away: "Seriously, will Chandoo go manualy thru all his Videos and pick the winners?!". Great connection to the give away with this tutorial 🙂 !