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