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
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
Hi FerdeOriginally Posted by 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
One way:
=SUM(COUNTIF(A1:A10,{"y","n"}))
In article <[email protected]>,
"ferde" <[email protected]> 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
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks