COUNTIFS Issue

[samleighcattrall]

Hello,

I am trying to do the following with a COUNTIFS Formula

G:G = "In Survey"
AF:AF = "" (Blank)
AD:AD = <>"" (Populated with data, but not specific)

My original formula looked like this:
=COUNTIFS(Data!G:G,"In Survey",Data!AF:AF,"",Data!AD:AD,"<>""")

However with or without data in AD, it's still counting it.

Any help would be appreciated.

 

[AhoyNC]

Try changing your formula to:
=COUNTIFS(Data!G:G,"In Survey",Data!AF:AF,"",Data!AD:AD,"<>")

Also, it's best to avoid using whole column references.

 

[samleighcattrall]

Try changing your formula to:
=COUNTIFS(Data!G:G,"In Survey",Data!AF:AF,"",Data!AD:AD,"<>")

Also, it's best to avoid using whole column references.

That hasn't worked. I've even changed to G3:G200 etc to see if that helped. But nothing.

 

[cspengel]

=COUNTIFS(Data!G:G,"In Survey",Data!AF:AF,"",Data!AD:AD,"<>"&"")

 

[AhoyNC]

Do you have any formulas on columns AF or AD?

 

[samleighcattrall]

=COUNTIFS(Data!G:G,"In Survey",Data!AF:AF,"",Data!AD:AD,">""")

This solved the issue.

 

[samleighcattrall]

Do you have any formulas on columns AF or AD?

Yes I do, Vlookup in these cells. I assume this is why it was not working. AD was the issue because of the <>"" and formulas, it just didn't like it

 

[AhoyNC]

Yes, if there is a formula in the cell then it is not blank which would throw off your count.