SumProduct
 

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

SumProduct
 

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

Although, why the avoidance of a PivotTable?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jack" wrote:

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

SumProduct
 

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.




"Jack" wrote:

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

SumProduct
 

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

"JLatham" wrote:

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.




"Jack" wrote:

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