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?

Find more posts tagged with

Formulas

Accepted answers

All comments

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,

Alex Argumedo

Hello,

Try:

=COUNTM([Department]@row)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.