Sumproduct

[shanibwino]

Hello friends,

I need help with finding the sum of the suppliers in my spreadsheet attached. Suppliers apperaing more than once should appear once in the result. The answer should appear on a separate sheet with one column showing the supplier names and the other showing the totals of each supplier. I also need to show the grand total. The SUMPRODUCT FUNCTION must be used...... please help.

[JieJenn]

I don't know why Sumproduct "MUST BE USED". Anyway, =SUMPRODUCT(IF($A$2:$A$20=E9,$B$2:$B$20)) hit with Ctrl + Shift + Enter since it is an array formula

[icestationzbra]

on jiejenn's workbook (cells F3 through F14), this would work too, with or without array formula:

=SUMPRODUCT(($A$2:$A$20=E3)*($B$2:$B$20))

[Paul]

Note that when anyone says a specific function or method MUST be used, it's 99.99% guaranteed that the person (aka "student") is trying to get us to do their homework. If they were smart, they would know otherwise. (Not saying it doesn't work in this case, but that's not really the point.)

[elinielsen]

A simple Pivot could easily do the trick.