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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!