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!

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!