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.