Countif for 2 different value under same column?

Rafsun RoyalRafsun Royal ✭✭✭✭✭
edited 12/09/19 in Using Smartsheet
11/29/18 Edited 12/09/19

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

Comments

  • 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 RoyalRafsun Royal ✭✭✭✭✭

    Great! Thanks Sterling!

Sign In or Register to comment.