Help with COUNTIF

SmartSheet Newbie

Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number of rows meeting the criteria in Category26 but excluding any rows in Sheet - Request Tracker Range 8 that are equal to Closed or Cancelled.

Paul Newcome

You would switch over to a COUNTIFS to include multiple range/criteria sets, include the new range, and then include the new criteria.

=COUNTIFS({Sheet - Request Tracker Range 9}, Category26, {New Range}, AND(@cell <> "Closed", @cell <> "Cancelled"))

Paul Newcome

You would switch over to a COUNTIFS to include multiple range/criteria sets, include the new range, and then include the new criteria.

=COUNTIFS({Sheet - Request Tracker Range 9}, Category26, {New Range}, AND(@cell <> "Closed", @cell <> "Cancelled"))