Using COUNTIFS with AND

deb_63_hydracor

Hi! I'm trying to count the number of items which have one status as "Operational" and another status with any option EXCEPT "Operational". This is the formula I have but it is getting an error as UNPARSEABLE. Note that I'm using a cross-sheet reference. Thanks!

Genevieve P.

Hi @deb_63_hydracor

The syntax of your formula looks correct. Would you be able to show screen captures of the two {references} in the pop-up window? (But please block out sensitive data).

Is it possible that either of these ranges have a formula in them which may be returning an error?

What happens if you try each criteria on its own, like so:

=COUNTIFS({SSL Exp Rounding Status}, "Operational")

=COUNTIFS({SSL EHR Integration Status}, <> "Operational")

Cheers!

Genevieve

deb_63_hydracor

Hi Genevieve! Thanks for your quick response! I got the formula to work! It's not giving me the correct answer, but at least no errors.

Thanks and have a great weekend!

Genevieve P.

Hi @deb_63_hydracor

I'm glad to hear you're no longer seeing an error! However the formula should give you the correct Count... if you're still having trouble please let me know and I'd be happy to take a look at some screen captures to see what may be happening.

Cheers,

Genevieve