Another great way that you can use the SUMPRODUCT function is to create a conditional sum criteria.

For example, you may want to find out how much sales were made above the $3,000 transactional level.  See how easy it is with this quick SUMPRODUCT example.

DOWNLOAD WORKBOOK

Advanced Sumproduct_Conditional Sum

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: Sum the Top 3 Sales ... This is probably the most advanced level a SUMPRODUCT function can reach and that is by including a nested array formula.In our example below we want to return the 3 Largest values from the North region and sum them up.  As we are asking our formula to perform multiple calcul...
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...
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...
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...