COUNTIF HELP W/BLANK CELLS
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.
Best Answer
-
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!
Answers
-
Try something like this...
=COUNTIFS(Telecommuter:Telecommuter, OR(@cell = "Permanent", @cell = "Temporary"), [Modified Status]:[Modified Status], AND(@cell <> "Furlough", @cell <> "Separated"))
-
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!
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!