COUNTIFS in Sheet Summary Formula

Hello,

I am trying to create a Sheet Summary variable that captures milestones completed last quarter.

I have the following formula in the summary sheet field:

=COUNTIFS(Status:Status, "Complete", Start:Finish, AND(@cell >= IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 4, 1), DATE(YEAR(TODAY()) - 1, MONTH(TODAY()) + 8, 1)), @cell < DATE(YEAR(TODAY()), MONTH(TODAY()), 1)))

But for some reason I keep getting the "incorrect argument set"

The status column is categorical, and Start/Finish are dates. Any help would be greatly appreciated. I hope to then move this output into a dashboard too.

Thank you!

Stephanie

Find more posts tagged with

Accepted answers

Paul Newcome

The problem is that your first range is a single column and your second range is (at least) two columns wide. You will need to adjust this so that both ranges are the same size and shape.

All comments

Paul Newcome

The problem is that your first range is a single column and your second range is (at least) two columns wide. You will need to adjust this so that both ranges are the same size and shape.

sharshman

Thank you!

Paul Newcome

Happy to help. 👍️

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.