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

Excel Subtotal Function – Include Hidden Val... What does it do?It returns a Subtotal in a list or databaseFormula breakdown:=SUBTOTAL(function_num, ref1)What it means:=SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data)***Go to the bottom...
SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify.So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...
Advanced SUMPRODUCT Function: Sum Multiple Criteri... What does it do?It returns the sum of multiple criteria from the corresponding ranges or arraysFormula breakdown:=SUMPRODUCT((array 1 criteria) * (array2 criteria) * array values)What it means:=SUMPRODUCT((find my criteria in this array) * (find my criteri...
Advanced SUMPRODUCT Function: Maximum Sales What makes the SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function.Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX fu...