Counting multiple criteria in one column

[datadummy]

I am trying to write a statement that essentially says if cells N14-N19 = either Y or NA count it as Y.

 

[Joe4]

One way:

=COUNTIF(N14:N19,"Y")+COUNTIF(N14:N19,"NA")

 

[DanteAmor]

Something like that



=IF(OR(COUNTIF(N14:N19,"Y")=6,COUNTIF(N14:N19,"NA")=6),"Y")

 

[datadummy]

If I wanted to take it a step further and account for those same cells and then divide them by the total number of entries in the specified cells to return a percentage what might that look like?

 

[Joe4]

Do you mean something like this?

=(COUNTIF(N14:N19,"Y")+COUNTIF(N14:N19,"NA"))/COUNTA(N14:N19)

 

[DanteAmor]

If I wanted to take it a step further and account for those same cells and then divide them by the total number of entries in the specified cells to return a percentage what might that look like?

You can put examples 3 or more examples of what you have in the cells and the result you expect.

 

[datadummy]

So heres what I have so far,
=COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019",ATRMC!N:N,"Y")+COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019",ATRMC!N:N,"NA")/COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019")
This is returning 250% rather than 83% there's 2 Y responses and 3 NA's and 1 N.

 

[Joe4]

Mathematical order of operations usually does multiplication and division before addition and subtraction. So you need parentheses around your first two COUNTIFS:

[COLOR=#333333]=[/COLOR][COLOR=#ff0000][B]([/B][/COLOR][COLOR=#333333]COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019",ATRMC!N:N,"Y")+COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019",ATRMC!N:N,"NA")[/COLOR][COLOR=#ff0000][B])[/B][/COLOR][COLOR=#333333]/COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019")[/COLOR]

 

[DanteAmor]

So heres what I have so far,
=COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019",ATRMC!N:N,"Y")+COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019",ATRMC!N:N,"NA")/COUNTIFS(ATRMC!$C:$C,">4/30/2019",ATRMC!$C:$C,"<6/1/2019")
This is returning 250% rather than 83% there's 2 Y responses and 3 NA's and 1 N.

Sorry, but I did not understand your examples I do not see the values ​​in the cells nor do I understand the dates.

[TABLE="class: grid, width: 210"]
<colgroup><col span="14"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD] 1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] 2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD] 7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]8 [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD] 9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD] 10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD] 13[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD] 14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]N[/TD]
[/TR]
</tbody>[/TABLE]

 

[datadummy]

That did the trick, thank you!!