COUNTIFS matches within a date range between 2 sheets

I have 2 different sheets, both with the same column name.

What formula would I use to be able to get a total number of matches between the 2 sheets within that column, but also only in 2023?

I use this to get the total within the date range, but how would I get a count of the number of matches between the column on 1 sheet and the column on the other sheet?

=COUNTIF([Date Complete]:[Date Complete], IFERROR(YEAR(@cell), 0) = 2023)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

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.