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.

A

B

C

D

E

F

G

H

I

J

K

L

N

1

2

Y

3

Y

4

Y

5

Y

6

N

7

N

8

N

9

N

10

Y

11

Y

12

Y

13

N

14

N

<colgroup><col span="14"></colgroup><tbody>
</tbody>

 

[datadummy]

That did the trick, thank you!!