Countifs with Or Function

Andrea Westrich

I'm trying to count people from another sheet where the goal year equals the one reference on the current row and the Status could be a few other options, so I thought the easiest would be the OR function with counting everything including blank, but not "Agent Not in Count".

The formula below gives me an #Unparseable error.

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell ""))

Genevieve P.

Hi @Andrea Westrich

It looks like you're just missing the = sign for when you're looking for ""!

Try this:

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell = ""))

Cheers,

Genevieve

Andrea Westrich

@Paul Newcome or @Genevieve P., do you know the answer? The problem is that the Status column can have 1 of 5 options or it can be blank. I need to count blanks and every status except Agent Not in Count.

I appreciate your help!

Genevieve P.

Hi @Andrea Westrich

It looks like you're just missing the = sign for when you're looking for ""!

Try this:

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell = ""))

Cheers,

Genevieve

Andrea Westrich

Hello @Genevieve P.,

You are SO amazing! That worked perfectly! This is so helpful for many uses, I really appreciate your help.

Thank you very much!!

Genevieve P.

No problem at all! I'm glad it was an easy fix 🙂