COUNTIF HELP W/BLANK CELLS

Donni Matthew

I am trying to count the number of employees that have access to work remotely and have not been furloughed or laid off. The columns I'm looking at are: MODIFIED STATUS & TELECOMMUTER. The values in Modified Status are: Furlough, Separated, Reduced Salary, Reduced Hours & Other. The values in Telecommuter are Permanent & Temporary.

I need to count all employees with the Telecommuter value of Permanent OR Temporary AND the Modified Status is NOT Furlough or Separated.

Any assistance with this formula is very appreciated.

Donni Matthew

I ended up having to do this: =COUNTIFS({AZ TELE}, OR(@cell = "Permanent", @cell = "Temporary"), {AZ MODIFIED}, OR(@cell = "", @cell = "Reduced Salary",@cell = "Reduced Hours",@cell = "Other (See comments)"))

But it worked!! Thank you so much!

Paul Newcome

Try something like this...

=COUNTIFS(Telecommuter:Telecommuter, OR(@cell = "Permanent", @cell = "Temporary"), [Modified Status]:[Modified Status], AND(@cell <> "Furlough", @cell <> "Separated"))

Donni Matthew

I ended up having to do this: =COUNTIFS({AZ TELE}, OR(@cell = "Permanent", @cell = "Temporary"), {AZ MODIFIED}, OR(@cell = "", @cell = "Reduced Salary",@cell = "Reduced Hours",@cell = "Other (See comments)"))

But it worked!! Thank you so much!

Paul Newcome

Happy to help. That's odd that the AND portion didn't work for you, but at least you were able to get it working.

Please be sure to flag the most appropriate response(s) as "helpful". That way others searching for a similar solution can know that one may be found here.