Sumif's On Rows and Columns for Excel And Google Sheets

How to create a Sumifs using both a row and column axis on a data range. You can use the formula SumProduct, which is available in Excel, Google Sheets, LibreOffice and probably anything else that calls itself a spreadsheet.

Worksheet from Video Shared On Google Sheets:

My Video below gives a short walk-through of it, but essentially you use SUMPRODUCT function. The syntax is basically SUMPRODUCT((Range1CONDITION=~VALUE~)*(Range2CONDITION =~VALUE~)*DATARANGE).

2-Dimensional Sumifs. Sumif by both rows and columns.

[dianasharon]

YESSS!!! THANK YOU!!! You just wrecked ALL THOSE SUMIFS and SUMPRODUCT videos on Youtube! Because almost all of them are strictly rows to row or columns to columns! Thank you again!!

[flaviobotelho]

Thanks a lot man !!!
I used your tip to create a sum for different ranges of dates.
Saved A LOT of time !!!
Awesome!

[AK-wyrp]

TO THE POINT, QUICK AND SO EASILY EXPLAINED, SUBSCRIBED

[josecarlosgameiro]

Thank you so much!! You just saved the day!!! Been wrecking our brains around with multiple formulas and this unlocked the solution.

[hb]

Perfect video, exactly when I needed it ..thanks a lot !

[alexmchenry]

PG, thanks for this simple example - just turned my world around.

[simpleeconomics]

you are a life saver!!! im using your method to calculate GVC. its a humungous dataset.

[randyabner]

Brilliant formula, super easy to follow. Thank You!

[AmeyShirke]

Awesome video..Since 2 weeks m struggling for this function!!!! Thanks a ton!!!

[ryivibes]

A big Thank you!! was trying to find a solution for so long!

[diannedrechsler]

Thanks, I just needed a reminder and you're vid was perfect!

[normacaldwell]

Thank you! Exactly what I was looking for.

[namratasakhare]

Thanks a lot. I spent a lot of time figuring out.

[sarahmurrey]

This was SO very helpful. Thank you!!!

[Scars_]

Awesome trick. I also thinking about sumif 2 dimentions.

[VanzJTutorials]

Thank you so much. It helps a lot to me.

[antonellac]

Hi, if some numbers are 0? How can we exclude zeroes?

[RobertLongM]

Can we not just use the whole column like A:A instead of just a short range that can likely grown in time? So far I can't find out how. Plus I need to sum up data throughout multiple rows that are not in sync (Next to each other)

[meranism]

Thank you for the information sir. I would like to see if there is a way to apply the same method for several columns? I have a sheet where I input my monthly expenses and I separated it by months. So each month has it's own expenses in different column. Is there a way to get a sum for a specific expense, let say (GAS)? I would really appreciate it if you could help me. Other wise the way I do it now I get a sum for each month and then add up all those numbers to get a sum of all. That's taking a long time to put the same equation for each month over and over again. =SUMIF(A3:A25, "*"&AI5&"*", B3:B25)+SUMIF(C3:C25, "*"&AI5&"*", D3:D25) - this is what I use. but I have to do it for 12 months. Is there a shortcut for achieving the same result?

[jayjayf]

I spent two hours thinking how to do sumifs for both row and column, turns out all u need is sumproduct