|
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? |
SumProduct
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) -- Don Guillett SalesAid Software "Moz" wrote in message ... 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? |
SumProduct
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" wrote: 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) -- Don Guillett SalesAid Software "Moz" wrote in message ... 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? |
SumProduct
Your are right!! Thank you!!!
"Don Guillett" wrote: 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 SalesAid Software "Moz" wrote in message ... 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" wrote: 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) -- Don Guillett SalesAid Software "Moz" wrote in message ... 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? |
SumProduct
Glad to help. Merry xmas
-- Don Guillett SalesAid Software "Moz" wrote in message ... Your are right!! Thank you!!! "Don Guillett" wrote: 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 SalesAid Software "Moz" wrote in message ... 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" wrote: 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) -- Don Guillett SalesAid Software "Moz" wrote in message ... 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? |
| All times are GMT +1. The time now is 02:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com