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?
|