count all the columns in a range with certain conditions
 

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

count all the columns in a range with certain conditions
 

Hi
If it is possible, try inserting a blank row above your range, you can
hide that row later. Now lets say that your range starts in column A
row 5, in your blank row starting on the second column (in your example
above John) put this formula:
=IF(AND(COUNTIF(B5:B7,"n")0,COUNTIF(B5:B7,"n")=CO UNTA(B5:B7)),1,0)
and copy across, to get the number of columns simply sum the row you
inserted.

P.S. you will need to ajust the formula for your range.....B5:B7

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=476956

count all the columns in a range with certain conditions
 

Brillant!!!

thank you so much once again JG. You are very giving to this
community.

keith


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

count all the columns in a range with certain conditions
 

Hi Keith
My knowlege of Excel is limited, but I'm always glad to help whenever
I can. And thanks again for the feedback, much apreciated.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=476956