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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Excel´s TEXT Function The TEXT function in Excel allows you to convert a numeric value to a specific format by using special format strings. If you have a date and want to show just the month or if you have a large number and want to show it in a thousands format , then the TEXT function is your sa...
Getting the length of text with Excel’s LEN ... What does it do? Gives you the number of characters of the text Formula breakdown: =LEN(text) What it means: =LEN(text that you want to get the number of characters) There are times when you need to get the number of characters within a cell in Excel.  Thank...
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...
In-Cell Bar Charts with the REPT Function When you are creating an Excel Dashboard and are limited by space and do not want to insert a chart, you can easily create an in-cell bar chart using the RPT (repeat) function. The RPT function uses the vertical bar character | as the first argument: text and references the va...