View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucas Thompson Lucas Thompson is offline
external usenet poster
 
Posts: 1
Default 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!