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

Match Two Lists With The MATCH Function I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2.Well I have!With the MATCH function you can verify if a cell´s item in List1 exists in List2.The function will return the r...
Concatenate With A Line Break Excel's CONCATENATE functions joins two or more text strings into one string.  The item can be a text value, number, or cell reference.If you add a double quotation with a space in between " " then this will add a space between the texts selected on either side.You ca...
Evaluate Formulas Step By Step in Excel This is one of the coolest tricks I have seen in Excel, as there are countless times wherein I had a hard time understand formulas. Especially long and complex ones!Excel provides the way to evaluate your formula, and break it down step by step so that you can understand it! ...
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...