The SUMIFS function allows you to Sum multiple criteria.

For example, you can select one Sales Rep from a list of Sales Reps and select one Region from a list of Regions and return the Sum of those arguments from a Sales list.  See how easy it is…

DOWNLOAD WORKBOOK

SumIfs - Intro

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

RANDBETWEEN Function I use the RANDBETWEEN function all the time whenever I need to create a sample data set.The cool thing about the RANDBETWEEN function is that if you don't like the numbers that it has given you, you can press F9 in a cell and it will give you new numbers.  Try it out by downl...
Advanced SUMPRODUCT Function: Conditional Date If you want to find out the total sales for a particular month, then the SUMPRODUCT function is your answer.  You can create a criteria for a specific date range, a particular month or a year.In the example below I show you how to use the SUMPRODUCT function to sum up the tot...
DATEDIF function: Introduction The DATEDIF function is a mystery function within Excel.  When you write it out in a workbook it doesn't give you any hints like other functions would and if you look it up in the function list you would not find it! Creepy...The DATEDIF function stands for "date difference" ...
Total Bonus Due With An Array Lookup Formula The LOOKUP function has three arguments, it is a like a simplified VLOOKUP function:What does it do?It looks up a value (lookup_value) in one range (lookup_vector) and returns a value from the same position in a second range (result_vector)Formula breakdown:=LOOKU...