Counting Rows in a date range

I've been trying to just create a formal in my sheet summary to show a count of issues i have on a sheet (number of rows) between a date range, so how many issues were raised in 2024, I've got a Row ID column with auto numbering which i'm trying to draw on but i keep getting error messages?

I feel like it's a simple count and date formula but I've search online and no variation seems to work

This is as far as i got

=COUNTIFS([Row ID]:[Row ID], [Date Raised]:[Date Raised], >DATE(2024, 1, 1), [Date Raised]:[Date Raised], <DATE(2024, 12, 31))

Any body have any ideas please?

Find more posts tagged with

Accepted answers

EVENCIA1234

Thanks TVang, i finally got it to work using the following!

=COUNTIFS([Date Raised]:[Date Raised], >=DATE(2025, 1, 1), [Date Raised]:[Date Raised], <=DATE(2025, 12, 31))

All comments

TVang

@EVENCIA1234 , try the following. Change the year as needed.

=COUNTIF([Date Raised]:[Date Raised], IFERROR(YEAR(@cell), 1970) = 2024)

I don't understand the reason, but summary fields don't seem to play well with dates. You have to wrap date functions within an IFERROR() function.

EVENCIA1234

Thanks TVang, i finally got it to work using the following!

=COUNTIFS([Date Raised]:[Date Raised], >=DATE(2025, 1, 1), [Date Raised]:[Date Raised], <=DATE(2025, 12, 31))

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.