SumProduct

[Guest]

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?

 

[Don Guillett]

Lots of stuff.
You can't use headings but you can name your ranges
=sumproduct("Product=FIReserve")*(Producer="MSE")*(Refund_LTT).
Your FORMULA (not statement) to sum c based on criteria in a and b
=sumproduct((a2:a22="FIReserve")*(b2:b22="MSE")*c2:c22)

 

[Guest]

I setup a Range a2:a30 named Period_rng, I also setup b2:b30 as
Producer_rng, I also setup Refund_LTT as c2:c30. I create a cell called
SelectMonth. Period_rng, Producer_rng, and SelectMonth are validated by a
list. SelectMonth and Period_rng use the same list Jan-07, Feb-07, etc to
Dec-07. When I type
=sumproduct(Period_rng=SelectMonth)*(Producer_rng="RSE")*(Refund_LTT) I get a
value error.

 

[Don Guillett]

When all else fails, use the proper syntax as I posted
=sumproduct(Period_rng=SelectMonth)*(Producer_rng="RSE")*(Refund_LTT)
=sumproduct((Period_rng=SelectMonth)*(Producer_rng="RSE")*Refund_LTT)

 

[Guest]

Your are right!! Thank you!!!

When all else fails, use the proper syntax as I posted
=sumproduct(Period_rng=SelectMonth)*(Producer_rng="RSE")*(Refund_LTT)
=sumproduct((Period_rng=SelectMonth)*(Producer_rng="RSE")*Refund_LTT)

 

[Don Guillett]

Glad to help. Merry xmas