Stuck in #UNPARSEABLE
I have a column titled "Department" for which there are multiple departments listed
I have another column with a specific set of numbers, 04.
What I am attempting to do is count the number of instances of 04 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?
Answers

=COUNTIFS(Department1:Department26, "Finance", [Converted  PPC1]2:[Converted  PPC1]27, 4)
I cleaned out a few pieces, but the actual problem was the square bracket after the 4.
Cheers,
dm

Hello,
Try:
=COUNTM([Department]@row)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!