In Excel 2002 Formulas, an array formula is suggested (pg. 190):
=SUM(IF((test1="Med")*(test2="Yes"),1))
In my case, test1 and test2 are parallel columns of data.
But this doesn't seem to work.??
-doug.
Fixed it!!!
didn't enter the array formula with CTRL+SHIFT+ENTER.
This message was edited by dgoldie on 2002-09-11 13:09
=SUM(IF((test1="Med")*(test2="Yes"),1))
In my case, test1 and test2 are parallel columns of data.
But this doesn't seem to work.??
-doug.
Fixed it!!!
didn't enter the array formula with CTRL+SHIFT+ENTER.
This message was edited by dgoldie on 2002-09-11 13:09