| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
