How to use @cell or @row in a COUNTIF formula

I am using the following formula:

=COUNTIFS({All Snap Data Dept Code}, ="12326", {All Snap Data Month}, "Sept")

to return the number of times a department number is used on a report in September. Easy enough, but there are almost 300 unique department codes. I tried clicking on the box with the departments (resulting in [Dept Code]@row being in the criterion1 place in the formula. However, this always results in a 0, even when there are 1 or more occurrences of that department to count.

=COUNTIFS({All Snap Data Dept Code}, [Dept Code]@row, {All Snap Data Month}, "Sept")

Is there any way to make this work so that the copy and paste down automatically references the department number (which is the column to the left of where the count formula is), rather than me having to type every single one and then copy and paste over and update the month for October, December, etc.

Both ranges are referencing a separate sheet (the same one but different columns)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!