Calculating totals for items with associated quantities over multiple rows

Hello everyone,
I have attached a sample spreadsheet in the hopes someone is able to assist me.

What I am trying to accomplish is to associate each product on the Distribution tab in 'E' to its associated quantity in 'F' so I can count the total number of each product and display this in 'D' on the Totals tab.

Once this is done, the total for each product would me multiplied by the associated price in 'C' on the Totals tab to achieve the total item value for each item in 'E'.

I have included the current results and what the correct values should be. As you can see, I tried to use 'Countif' with no success. I could not find any solutions in the forum that were close enough to this situation to work.

Thanks in advance for your help!!

Andrew

change formula in D3 to:

=SUMIF(Distribution!E:E,A3,Distribution!F:F)

and copy it down.

Hi Andrew,

I think you are using the wrong function.

Use SUMIF Instead of COUNTIF.

Why?

COUNTIF counts values in a range that meet one criteria; For example count all JOHNs in the Employee Name Column.

Your case is different...

You have the criteria in one column and the values to sum in another one; SUMIF does this very efficiently.

I attached the solution

Don't stop there, learn more about these functions, visit:

http://www.excel-spreadsheet-authors.com/sumif.html
http://www.excel-spreadsheet-authors.com/countif.html

drewship,

See the attached "Products.zip", containing workbook "INDEX MATCH SUMPRODUCT - Calculating totals for items with associated quantities over multiple rows - Products - drewship - SDG.xls"