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.

SUMIF Function: One Criteria & Sum Range | MyExcelOnline

DOWNLOAD WORKBOOK

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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