CountIf formula for status and priority

Salicce1

I am trying to code a count if formula for two columns so I would like to count by status and priority. I have the table created and the values manually entered, but I would like to code this to summarize the sheet values automatically. Does anyone know the formula to use?

Paul Newcome

You would use a COUNTIFS function.

https://help.smartsheet.com/function/countifs

Salicce1

I am using this formula and it is still showing #UNPARSEABLE... any idea what the issue is? =COUNTIFS({Gold Card Program RAID Log Range 1}[Priority]:[Priority], "Critical",{Gold Card Program RAID Log Range 2}[Status]:[Status], "Pending")

Paul Newcome

Your syntax for your cross sheet references is a bit off. Give this article a read and see if that helps clear things up.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references