Metric Sheet Countifs formula is not quite right - what am I doing wrong?

Todd101984

These first two formulas work in this Metric Sheet.

=COUNTIF({Level-ones}, $[Primary Column]@row)

=COUNTIF({Status}, [Column5]$23)

As seen by the returned values 66 and 21.

When trying to combine as COUNTIFS, it gives unparseable reply for the following formula.

=COUNTIFS({Level-ones}, $[Primary Column]@row1, {Status}, [Column3]$23)

(I also tried =COUNTIFS({Level-ones}, $[Primary Column]@row, {Status}, [Column]$23) variations and without $)

My data source for these columns:

Find more posts tagged with

Accepted answers

heyjay

Can you try to remove the '1' on this arguement and see it that works:

All comments

heyjay

Can you try to remove the '1' on this arguement and see it that works:

Todd101984

I did and also the 3.

Todd101984

Oh my goodness - I tried it again and it worked. Thank you!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.