Countif is not working when trying to count results from if/and Statement

[rengifot]

Hi All,

I am trying to count all the "Yes" on column AY (<4 Fills) but formula COUNTIF only returns zeros, field AY52. By the way, the "Yes" are the result of using the if/and statement so I am sure if that that is the reason the COUNTIF formula is not working.

 

[Eric W]

I can't quite tell from that picture, but I think your AY8 formula should be:

=IF(AND(AX8="YES",V8>3),"","YES")

with a small change in the AND. And I'm not sure why your COUNTIF isn't working, but is there a space after the "YES" in the AY8 formula? If so try this:

=COUNTIF(AY3:AY51,"YES*")

 

[rengifot]

New Patients Q1 Q2 201804 201805 201806 201807 201808 201809 201810 201811 201812 201901 201902 201903 New Patient? <4 Fills New Yes New Yes New Yes Yes IF((AND(AX8,"Yes",V8>3))," ","Yes ") New Yes Yes New Yes New Yes Yes Yes New Yes New Yes Yes Yes New Yes New Yes New Yes Yes New Yes Yes New Yes Yes Yes Yes New Yes Yes New Yes Yes New Yes Yes Yes Yes Yes Yes Yes Yes New Yes Yes Yes New Yes Yes Yes Yes Yes New Yes Yes Yes Yes Yes Yes New Yes Yes Yes 1​ 1​ 2​ 3​ 4​ 1​ 2​ 0​ 1​ 1​ 2​ 2​ 20​ COUNTIF(AY3:AY51,"Yes")

I can't quite tell from that picture, but I think your AY8 formula should be:

=IF(AND(AX8="YES",V8>3),"","YES")

with a small change in the AND. And I'm not sure why your COUNTIF isn't working, but is there a space after the "YES" in the AY8 formula? If so try this:

=COUNTIF(AY3:AY51,"YES*")

Thanks Eric W. It worked!!

 

[Eric W]

Happy to help! ?