Help with SumProduct or Sum Array Formulas

[Lucas Thompson]

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"})*(edbc>from)*(edbc<to))}

-OR-

{=SUM((edbc>from)*(edbc<to)*(program="30")*(action="a")*(age<31)+((edbc>
from)*(edbc<to)*(program="30")*(action="d")*((age<31))+((edbc>from)*(edb
c<to)*(program="32")*(action="a")*(age<31)+((edbc>from)*(edbc<to)*(progr
am="32")*(action="d")*((age<31))+((edbc>from)*(edbc<to)*(program="33")*(
action="a")*(age<31)+((edbc>from)*(edbc<to)*(program="33")*(action="d")*
((age<31))+((edbc>from)*(edbc<to)*(program="35")*(action="a")*(age<31)+(
(edbc>from)*(edbc<to)*(program="35")*(action="d")*((age<31))+((edbc>from
)*(edbc<to)*(program="cw")*(action="a")*(age<31)+((edbc>from)*(edbc<to)*
(program="cw")*(action="d")*(Lang="s")*((age<31))))))))))))}

 

[Dick Kusleika]

Lucas

Maybe this

=SUM((age<=31)*((action="A")+(action="D"))*((program="30")+(program="32")+(p
rogram="33")+(program="35")+(program="cw"))*(edbc>from)*(edbc<to))