Thread: SumProduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Moz Moz is offline
external usenet poster
 
Posts: 11
Default SumProduct

I currently am setting up a spread sheet with the following excel
headings.Period Product Producer Vendor Stk # Orig Sale "Refund
Vendor" "Refund
LTT" "Total
Refund"
Jan-07 FIReserve RSE Galt 12345 2,759.42 1,240.89 896.40 2,137.29

I am trying to use SumProduct to but keep getting a value error. The
statement that I am using is
=sumproduct("Product=FIReserve")*(Producer="MSE")* (Refund_LTT).

What am I doing wrong?