COUNTIF differnt sheet

CameronKeel

Hey I have a sheet with a column "Status" and I am trying to write a formula to count totals for the different statuses. Reference sheet name is "Conference Room Request Form" the status I am looking for is "PO Cut"

=COUNTIF({Conference Room Request Form v2 Range 1}(Status:Status,"PO Cut"))

I get a #UNPARSEABLE

What am I missing?

Mary Royston

Hey @CameronKeel,

Is the Conference Room Request Form Range 1, the range where the Statuses are? If so, the formula would be =Countif({Conference Room Request Form v2 Range 1}, "PO Cut")

Mary Royston

Hey @CameronKeel,

Is the Conference Room Request Form Range 1, the range where the Statuses are? If so, the formula would be =Countif({Conference Room Request Form v2 Range 1}, "PO Cut")

CameronKeel

@Mary Royston that worked, and I see what I was doing wrong. THX!!