#Incorrect Argument Set with =COUNTIFS

Hi all,

This is baffling me. I have a very simple formula...

=COUNTIFS({Epic Name}, [Primary Column]@row, {Current Sprint}, 1).

I am using this for a metrics sheet to be used for dashboard reporting. This is working as expected in it's own sheet but when I use the exact same formula in a bigger/consolidated metric sheet, it returns "#Incorrect Argument Set".

Does anyone know why it works on one sheet but not another?

Thanks,

Dave

Find more posts tagged with

Formulas

Accepted answers

DKazatsky

Update:

It looks like the reference was the issue when I cut/paste the formula. Even thought the same reference was being used in the current sheet, when I reinitialized the reference, everything worked as expcted.

Thanks.

All comments

DKazatsky

Update:

Thanks.

Genevieve P.

Hi @DKazatsky

I'm glad to hear this was resolved for you! Thanks for posting your solution.

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.