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!