Thread: SumProduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jack jack is offline
external usenet poster
 
Posts: 186
Default 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