COUNTIFS with Cross-sheet references

I'm trying to get a count of rows between two dates AND where we have the status as one of three choices.

I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column next to status called 'Concluded' to evaluate whether or not the ticket's current status is one of the three I want - where TRUE = 1.

I keep getting the incorrect argument error when incorporating these cross-sheet references into my COUNTIFS formula. I don't understand how the range sizes could differ when all I've done for the reference is select the entire column of 'Finish Date' and 'Concluded'

What am I doing wrong? Here's the formula I'm working with at the moment. Thanks for any advice!

=COUNTIFS({Finish Date}, >Start43, {Finish Date}, <Finish43, {Concluded}, 1)

Find more posts tagged with

Formulas

Reports

functionality

Accepted answers

All comments

Nasir@EBC

Hello Marry

It seems that you have overlooked the first cell range (referred to as range_1, which this function actually counts) in your formula.

I suggest that you please share a screenshot of the sheet where these data actually appear to have a clear idea of what needs to be done.

You may replace any sensitive data before taking and sharing the screenshot.

regards

Nasir (Zealvert)

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.