SumProduct

J

Jack

I would like to crate a table - not using pivot tables

Original table

A B C
Apple Green $4.00
Apple Green $2.00
Apple Red $1.00
Orange Yellow $4.00
Orange zebra $3.50
Orange zebra $1.00

Result Table
Apple Green $6.00
Apple Red $1.00
Orange Yellow $4.00
Orange zebra $4.50


thanks
 
L

Luke M

Something like this?
=SUMPRODUCT(--(A2:A10=A15),--(B2:B10=B15),C2:C15)

Although, why the avoidance of a PivotTable?
 
J

JLatham

Assuming that original table is on 'Sheet1' and starts in row 2, and that the
Result table is on another sheet and also starts on row 2.

In C2 on the second sheet (part of the Result table), put this formula:
=SUMPRODUCT(--(Sheet1!A$2:A$7=A2),--(Sheet1!B$2:B$7=B2),(Sheet1!C$2:C$7))
that will then fill on down the sheet for as far as your table extends.
 
J

Jack

this did not create the summary table i gave in my example. It did come up
with the totals but not a summary
 
Top