The SUMIF function can also be used to apply the criteria to one range and sum the corresponding values in a different range.

So if you have a list of Sales Reps in one list and their Sales in another list and want to Sum the sales of only one of the Sales Reps, then the SUMIF function is the one for you.

DOWNLOAD WORKBOOK

SumIf - Criteria & Sum Range2

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

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...
GETPIVOTDATA Function What does it do?A formula that extracts data stored in a Pivot TableFormula breakdown:=GETPIVOTDATA(data_field, pivot_table, , ,...)What it means:=GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...) T...
IF Function Combined With The AND Function When combining (or nesting) the AND function with the IF function, it allows you to add more than one condition to your formula, something that is not possible with the IF function by itself.So you can show the results of Sales Reps that have made more than $3,000 of sales AN...
How To Use INDEX-MATCH Formula The VLOOKUP formula searches for a value in the first column of an array and returns a value to the right of that array.How about if you wanted to return a value to the left hand side of that array?Well, this is where the INDEX-MATCH formula comes in and gives you a helpi...