Formula that counts # of incidents across a date range

I have a sheet for all incidents in the company that was started in 2023 and now that we're in 2024 I need to update some formulas so it only pulls the data for the current year.

Right now the formula is =COUNTIFS({Incident Type}, [Primary Column]@row) but this doesn't take the date range into consideration.

What should this formula be?

Find more posts tagged with

Formulas

Accepted answers

All comments

Zachary Hall

You could update the formula like this:

=COUNTIFS({Incident Type}, [Primary Column]@row, {Incident Date}, YEAR(@cell)=2024)

Jodi C

Thanks, @Zachary Hall!

On the same sheet, I am pulling the sum of all costs and need it to be based on a date range. what does this look like?

Zachary Hall

Since it is all in the same sheet you could use the formula below, updating your column names to match what they are in your sheet:

=SUMIFS([Cost]:[Cost], [Date]:[Date], YEAR(@cell)=2024)

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.