Stuck in #UNPARSEABLE

Rofonic27

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?

Dale Murphy

@Rofonic27

=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

Alex Argumedo

Hello,

Try:

=COUNTM([Department]@row)