counting text in a column
 

MD RN RT
y na na
n y y
y n na
na y n

I would like to total the Y and N from each column but ignore the NA

Thank you for your help
ferde

One way:

=SUM(COUNTIF(A1:A10,{"y","n"}))

In article ,
"ferde" wrote:

MD RN RT
y na na
n y y
y n na
na y n

I would like to total the Y and N from each column but ignore the NA

Thank you for your help
ferde

Hi

Assuming you column heading is in A1, paste this in an empty cell

=COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N")

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=395841

ferde Wrote:
MD RN RT
y na na
n y y
y n na
na y n

I would like to total the Y and N from each column but ignore the NA

Thank you for your help
ferde

Hi Ferde

Assuming Header rows are in row 1, and data in a2:c5

To Count just the "Y"'s use =COUNTIF(A2:A5,"Y") in A6 and drag across
to C6

To Count just the "N"'s use =COUNTIF(A2:A5,"N") in A6 and drag across
to C6

And to count both use =COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N") in A6 and
drag across to C6


Change ranges to suit your data


Hope this helps

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=395841

Thank you so much , it works great

"Colin Vicary" wrote:


Hi

Assuming you column heading is in A1, paste this in an empty cell

=COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N")

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=395841