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

Download the featured file here: www.bluepecantraining.com/wp-...
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.
------------------------

[@IvanCortinas_ES]

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

[@user-de7ef8wd4n]

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

[@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

[@supriyobanerjee7239]

Absolutely great. One of the gem video

[@marianopitre]

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

[@naveedyousaf1657]

Thank you Chester.

[@kartikey31]

Thanks for sharing these formulas.

[@Jakeyosaurus]

thank you this fixed everything this was a great help!!!!!! :)

[@vilcheesey]

life saver man, thank you

[@takuyamatsuda7214]

Thank you so much

[@user-vc2pl6yn5v]

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

[@sonykrokett1720]

Thank you very much. God bless you :D

[@usmaniqbal1836]

Perfect 👍

[@FrankTurbi]

Big thanks!

[@nataliiasatanivska9220]

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

[@thkim9749]

감사합니다. 도움이 많이 되었어요 Thank you.😊

[@peterjarabek5541]

Superb explanation:) Thanks indeed

[@Priteshpriyadarshi]

Thanks for helping

[@ShyamSunder-don]

Superb

[@fionamurphy1000]

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

[@johnpaulhernales6514]

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.

[@GarethJones-rv6yj]

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

[@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.

[@karunakarvemishetty1134]

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

[@Mishkafofer]

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

[@solcambs]

use a different array for each month

[@teoxengineer]

And also there are some formulas which gives same result like: • DSUM function =DSUM(Sales[#All];"Total";K1:L2) • LET function =LET(table;Sales[#All]; AllCriteria;Sheet1!K1:L1; Header;Sales[#Headers]; WritingCriteria;"Total"; Criteria1;Sheet1!K2; Criteria2;Sheet1!L2; Result; TOTAL(FILTER(CHOOSECOLUMN(table;XMATCH(AllCriteria;Header;0);XMATCH(WritingCriteria;Header;0)); (CHOOSECOLUMN(CHOOSECOLUMN(table;XMATCH(AllCriteria;Header;0);XMATCH(WritingCriteria;Header;0));1)=Criteria1)* (CHOOSECOLUMN(CHOOSECOLUMN(table;XMATCH(AllCriteria;Header;0);XMATCH(WritingCriteria;Header;0));2)=Criteria2))); Result )

[@jeffreymayo2883]

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

[@malaven11]

Same question here, how do you build the selector boxes on the right hand side of the sheet?

[@evrentuskan]

Data Menu --> Data Validation (Allow = List) Source = Account Holder; International; Store; Web@@malaven11