Countif for 2 different value under same column?

Rafsun Royal

I am using this but showing "Invalid Operation:

=COUNTIF([Current Overall Status]:[Current Overall Status], "QA") + =COUNTIF([Current Overall Status]:[Current Overall Status], "UAT")

I am trying to count the total tasks that are in either QA or UAT.

HELP!

Thanks,

Rafsun

Sterling

Hi Rafsun,
I think the problem in this case was the extra =.

=COUNTIF([Current Overall Status]:[Current Overall Status], "QA") + COUNTIF([Current Overall Status]:[Current Overall Status], "UAT")

Hope this helped!

Rafsun Royal

Great! Thanks Sterling!