COUNTIFS Issue

sj2022

Hi all - I am creating a calculation sheet that reference a ticket intake smart

sheet. I want to use this calculation sheet to count based on the country that submitted it and what the status of the ticket is.

Complete = Complete

Open = Not Started, In Progress, Blocked

Reference intake sheet:

I keep getting #UNPARSEABLE when I use the range of the country in the intake form and use the cell in the calculation sheet, and range of status column and range of cells in calculation sheet.

Paul Newcome

You would use a COUNTIFS along the lines of

=COUNTIFS({Country}, HAS(@cell, Country@row), {Status}, @cell = "Complete")