Excel: Sum Across Multiple Columns With One or More Criteria - 3 Methods

In this video I demonstrate three methods for summing across multiple columns with one or more criteria. This can't be done using the SUMIF or SUMIFS functions as the sum range has to be the same size as the criteria range(s), that is unless you add a total column and use this as the sum range. If you don't want to or can't add a total column you can either use SUMPRODUCT or SUM and FILTER combined.
------------------------

[deefwdn]

THANK YOU!!!! This was so straightforward!!

[IvanCortinas_ES]

Excellent resolution. The method I prefer is the one that uses the FILTER function. Thank you Chester!!!

[supriyobanerjee]

Absolutely great. One of the gem video

[stanleygeeks]

thank you for sharing this. You are a great teacher i can tell, im so grateful to found this video. Bless you good soul!

[Rovshankhuduyev]

Thank you sir for great explanation, you made my day better

[vcplynv]

How to get sum of selected columns only like sum of only Jan and Apr

[marianopitre]

wonderful, it sorted a big problem I had with a huge table!

[Jakeyosaurus]

thank you this fixed everything this was a great :)

[nataliiasatanivska]

It works! thank you very much for sharing this hint!

[GarethJones-rvyj]

I have created a similar formula based on your methods. this sums the totals in the columns =SUM(INDEX(C3:F12, 0, MATCH(Q9, C2:F2, 0))) however how could i also incorporate a date range (start date cell and end date cell) is this possible?

[waszeforumdialogu]

hi can you please help - I data presented by month and I do not want to sumifs based by criteria I want the sumifs to sum me the data based on the dropped selected month - can you please help

[fionamurphy]

How would you do this is you wanted to sum up the amounts based on the month? Does it work horizontally?

[mayenkothbisseck]

What if I'd also want to include column-based criteria? ie: Additionally to your criteria, I need the columns that match my expected result?

[FrozenSpector]

How would you pull out a list of the months/headers in this scenario where some of the data are 0?
Eg: April 1, May 1, June 1, July 0, August 1.
to return: “April-June, August” with each row being unique.

[johnpaulhernales]

Hello just wondering maybe someone could help. What if I need to include only data until March. Let's say I have a cell with "As of" criteria? Thanks.

[teoxengineer]

And also there are some formulas which gives same result like:
• DSUM function

• LET function
=LET(table;Sales[#All];
AllCriteria;Sheet1!K1:L1;
Header;Sales[#Headers];
WritingCriteria;"Total";
Criteria1;Sheet1!K2;
Criteria2;Sheet1!L2;
Result;



Result
)

[Mishkafofer]

What if I need to chose what month or some of the months?

[karunakarvemishetty]

Hi Sir, 3 condition or 3 criteria.... how to apply kindly help Sir

[jeffreymayo]

How would you get the values with a selector for Product Group and the Month?