SumProduct

  • Thread starter Thread starter Jack
  • Start date Start date
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
 
Something like this?
=SUMPRODUCT(--(A2:A10=A15),--(B2:B10=B15),C2:C15)

Although, why the avoidance of a PivotTable?
 
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.
 
this did not create the summary table i gave in my example. It did come up
with the totals but not a summary
 
Back
Top