I have a column titled "Department" for which there are multiple departments listed

I have another column with a specific set of numbers, 0-4.

What I am attempting to do is count the number of instances of 0-4 based on a specific department.

I have tried this formula in multiple ways and I cannot get it to work. Latest version.....

=COUNTIFS([Department]1:[Department]26,"Finance",[Converted - PPC1]1:[Converted - PPC1]26,"4"]))

I would repeat this formula in 4 more cells to sum for 0, 1, 2, & 3.

What am i doing wrong here?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!