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