I need to count all the columns in a range with these conditions: if
they contain entries; and are the entries only 'n' values.

'y'= goal met 'n'=goal not met

.........................................john..... .sues......mary.....jack
improved attendance..............y............n............ .........n
increased time in
class............y............y................... ..n
grade/course
completion.......................n................ ........

I want the formula to come back as =1 because only jack has these
goals, and he did not achieve these goals.

In order to chart this i would also need a formula that tells me how
many students had goals in their column (not how many goals, or the
result, just if they had any goals).

Thanks!!!
keith


--
hopeace
------------------------------------------------------------------------
hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009
View this thread: http://www.excelforum.com/showthread...hreadid=476956