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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Advanced SUMPRODUCT Function: Count You can use the SUMPRODUCT function to create advanced analysis of your data set.  For example, you can calculate the number of time a sales rep has made sales in a particular region.  Watch below to see how easy it is to create a count with this advanced SUMPRODUCT function. ...
INDEX Function Introduction The INDEX function in Excel returns a cell´s values from within a table/array. It works like a map, so you have to select a range (table/array) and tell it to return you the coordinates (Row & Column numbers). So if you want to return values from a Price List or large d...
VLOOKUP Multiple Columns What does it do? Searches for a value in the first column of a table array and returns the sum of values in the same row from other columns (to the right) in the table array. Formula breakdown: {=SUM(VLOOKUP(lookup_value, table_array, {col_index_num1,col_index_num2}, ))}...
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...