COUNTIF (or) COUNTIFS???

[jason.hampton]

Group,

I am attempting to create a COUNTIF sytanx with the following criteria:

1. Column F3:F102 = "Y"
(AND)
2. Column G3:G102 = "N"
3. Column G3:G102 = " " ---{blank}

I have started with this argument and am getting the "NAME" error message.

=COUNTIF(AND(F3:F102="Y",G3:G102="N",G3:G102="")

Is this better suited in a COUNTIFS argument? Any ideas?

[jason.hampton]

I also just tried this with no luck

=COUNTIF(F3:F102,"Y")*AND(G3:G102<>"Y")

[AlKey]

Try this one

Please Login or Register  to view this content.

[jason.hampton]

AlKey,

Thanks! That works perfectly.