Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with SumProduct or Sum Array Formulas
I can't get either of the following formulas to work, what can I
do...any suggestions would be greatly appreciated. {=SUMPRODUCT((age<=31)*(action={"A","D"})*(program ={"30","32","33","35", "cw"})*(edbcfrom)*(edbc<to))} -OR- {=SUM((edbcfrom)*(edbc<to)*(program="30")*(action ="a")*(age<31)+((edbc from)*(edbc<to)*(program="30")*(action="d")*((age< 31))+((edbcfrom)*(edb c<to)*(program="32")*(action="a")*(age<31)+((edbc from)*(edbc<to)*(progr am="32")*(action="d")*((age<31))+((edbcfrom)*(edb c<to)*(program="33")*( action="a")*(age<31)+((edbcfrom)*(edbc<to)*(progr am="33")*(action="d")* ((age<31))+((edbcfrom)*(edbc<to)*(program="35")*( action="a")*(age<31)+( (edbcfrom)*(edbc<to)*(program="35")*(action="d")* ((age<31))+((edbcfrom )*(edbc<to)*(program="cw")*(action="a")*(age<31)+( (edbcfrom)*(edbc<to)* (program="cw")*(action="d")*(Lang="s")*((age<31))) )))))))))} *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with SumProduct or Sum Array Formulas
Lucas
Maybe this =SUM((age<=31)*((action="A")+(action="D"))*((progr am="30")+(program="32")+(p rogram="33")+(program="35")+(program="cw"))*(edbc from)*(edbc<to)) -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com Lucas Thompson wrote: I can't get either of the following formulas to work, what can I do...any suggestions would be greatly appreciated. {=SUMPRODUCT((age<=31)*(action={"A","D"})*(program ={"30","32","33","35", "cw"})*(edbcfrom)*(edbc<to))} -OR- {=SUM((edbcfrom)*(edbc<to)*(program="30")*(action ="a")*(age<31)+((edbc from)*(edbc<to)*(program="30")*(action="d")*((age< 31))+((edbcfrom)*(edb c<to)*(program="32")*(action="a")*(age<31)+((edbc from)*(edbc<to)*(progr am="32")*(action="d")*((age<31))+((edbcfrom)*(edb c<to)*(program="33")*( action="a")*(age<31)+((edbcfrom)*(edbc<to)*(progr am="33")*(action="d")* ((age<31))+((edbcfrom)*(edbc<to)*(program="35")*( action="a")*(age<31)+( (edbcfrom)*(edbc<to)*(program="35")*(action="d")* ((age<31))+((edbcfrom )*(edbc<to)*(program="cw")*(action="a")*(age<31)+( (edbcfrom)*(edbc<to)* (program="cw")*(action="d")*(Lang="s")*((age<31))) )))))))))} *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Help with an array and SUMPRODUCT | Excel Worksheet Functions | |||
Sumproduct array | Excel Worksheet Functions | |||
array formulas-sumproduct and average | New Users to Excel |