Excel Quick Tips - How to use the SUMIFS function

Excel Quick Tips - How to use the SUMIFS function

Grab my FREE Excel for Analytics Ultimate Guide here: https://www.tmbanalytics.com/excel-fo...

Want to learn some helpful Excel functions? In this short I show you a quick use case for the SUMIFS function to instantly sum the volume for each region from my example data set, which you can access if you check out my Excel for Analytics project series here: Excel for Analytics Project Series

The Syntax is as follows:
=SUMIFS(Sum Range, Criteria 1 Range, Criteria 1, Criteria 2 Range, Criteria 2, etc.)

Where:
Sum Range means what it is you're wanting to sum up
Criteria Range means the series of data that has criteria you want to consider
Criteria here means what specific criteria from the range you want to sum against

In our example we grab the volume range to sum, then our criteria range comes from our region ID column and we sum against our criteria list, which are the unique regions.

Have fun!

#excel #exceltips #analytics #data #dataanalytics #excelfunctions #tmbanalytics #SUMIFS

• #people_blogs
• #microsoft_excel
• #excel_tips
• #learn_excel
• #excel_tricks
• #excel_training_for_beginners
• #excel_training
• #microsoft_excel_for_beginners
• #microsoft_excel_basics
• #excel_quick_tips
• #excel_quick_tips_how_to_use_the_sumifs_function
• #how_to_use_the_sumifs_function
• #sumifs
• #sumifs_excel
• #sum_ifs_excel
• #sumif_excel
• #sum_if
• #sum_if_excel
• #sumifs_formula
• #sumifs_excel_formula
• #sumifs_formula_excel