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.


Advanced Sumproduct_Conditional Sum

Helpful Resource:

If you like this Excel tip, please share itEmail this to someone


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...