📶 SUMIFS in Excel | Multiple Criteria & Multiple Sheets

Let's Practice SUMIFS in Excel - Here we review multiple criteria with multiple sheets in this Excel Tutorial. In the video I walk through a sample set of data where we add up the total amount of based on the criteria. There's about 3 examples here where they keep adding more criteria to hopefully make things more clear.
Excel Tutoring - The SUMIFS "adds all of its arguments that meet multiple criteria".
Argument Name - Description
Sum_range - The range of cells to sum.
Criteria_range - The range that is tested using Criteria1. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.
Criteria1 - The criteria that defines which cells in Criteria_range1 will be added.
Criteria_range2, criteria 2 - Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.
I recommend practicing with SUMIFS as opposed to SUMIF, due to the way the inputs are switched around between the two which may get confusing. Here is the regular SUMIF, if you're into that kind of thing: • Let's Learn the SUMIF ...
Supplemental reading:
SUMIFS:
snip.ly/xzn40f
SUMIF:
snip.ly/y4ibs4
Here is the practice document for you to download: docs.google.com/spreadsheets/...
Time codes:
0:00 - Practice SUMIFS with 1 Criteria
5:19 - SUMIFS Example with multiple criteria
Verdexes 2020 Compilation Video: • 2020 Compilation of Ve...
Check out Verdexes on more Social:
Instagram: / verdexes
LinkedIn: / verdexes
Twitter: / verdexes
Verdexes Merch: teespring.com/stores/store-of...
#verdexes #sumifs #exceltips #excelpractice #exceltutorial #spreadsheets #excelfunctions #sumif #excel #msexcel #excelfunction #advancedexcel #msexceltutorial #excelhelp #sumif

[@jelajahsebanten]

Good sharing, my brother Thanks

[@Verdexes]

Thanks for watching!

[@conferenceroom5963]

Hi, how to sum a random same heading (commission) in one column and figure in the next column. Please help in this regard

[@Verdexes]

Hi! Thanks for watching - just to make sure I'm understanding, if for example you're looking at the table at 5:22, you're asking if you can add the sumifs created in Column C to the sumifs created in Column D?

[@sathyanarayanansatagopan9069]

Please explain date wise debit and credit total in two columns and balance in next line.

[@Verdexes]

Hi! Thank you for watching - this sounds like a new scenario, correct? It would depend on the format of the data that you are working with. Is the data formatted where a column is maybe "Type" and in each row it reflects either "debit" or "credit"? Kind of like in the video above, where the "Item of Sale" column has all the items listed underneath it?

[@kimyenchu]

Hello, do you know how to sumifs 2 different columns on 2 sheets? I have 2 sheets with the same column names but one sheet is C column and one is D column. I can sumifs both sheets with the same column C but not different column.

[@Verdexes]

If I'm understanding correctly you would just add the two SUMIFS Functions together in the same cell Something like this: =SUMIFS(F17:F23,E17:E23,F31)+SUMIFS(J17:J23,I17:I23,F31) Test each SUMIFS Function independently first to make sure you're getting the right numbers and help troubleshoot if needed

[@ubaidillahmuhammad20]

nice.. put practiced file in the description video

[@Verdexes]

You are now able to download the Excel for practice

[@Verdexes]

Thanks for over 20k views!

[@elizabethnguyen8301]

Thankk you for saving my grades, this is so useful but i need some help in the "double clicking to repeat formula downwards", why does mine appear as 0 ? it seems that the formula was not repeated, help please

[@elizabethnguyen8301]

it seems when i drag down it moves down a cell, do i use f4 for every criteria range to fix it?

[@Verdexes]

​@@elizabethnguyen8301 Hey! Thanks so much for watching - In the above example the criteria range highlights the entire column, it won't really matter if you lock it in with F4 or not but if you are selecting a specified range (ex: A1 to A23 as opposed to A:A) you will definitely need to lock in with F4. Does that help?

[@elizabethnguyen8301]

@@Verdexes I’ve got it after rewatching you tutorial again !! This was most helpful!! Will definitely look to ur channel for more help 😭🙏🏼🙏🏼

[@elizabethnguyen8301]

Yup this helps , I needed to lock the criteria range in place and it worked perfectly after that. Data cleaning is so tough , this really helped speed things up 👍🏻👍🏻

[@Verdexes]

@@elizabethnguyen8301 Really glad to hear that!

[@williemungai1954]

Hi, why are you not locking the month?

[@Verdexes]

Not sure which part you mean but you should lock the criteria range especially when you are going to drag the formula to autofill!

[@DoranSteven]

It was going well until you used $C$2 and started manually amending each formula ... instead of locking only the row (C$2) so as to drag across and fill down.

[@Verdexes]

Love this!