Nested Or within Countifs formula
Hi,
I am hoping to see if I can get help with the following formula:
=COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], <>"internal comms")
Essentially, my goal is to count items that are for "HGIT" that are either complete or approved but not related to internal communication. I am using the brackets in this example to illustrate an entire column.
Thanks in advance!
-Jake
Answers
-
=COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", Channel:Channel, <>"internal comms") + COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Approved", Channel:Channel, <>"internal comms")
Resolved my issue. Apparently you cannot nest an "Or" statement within countifs as it is an "and" based function.
Help Article Resources
Categories
Check out the Formula Handbook template!