Help please!

I'm stuck on a formula. I'm trying to count data in a column in another sheet when the date in a separate column in that sheet is 2025. I think I'm getting stuck on having to use the IFERROR function with the year.

Here's my metrics sheet

And here's the source. I want to count the cells in Quote Value when Quote Complete Date Year = 2025

Thanks in advance for any help you can provide!

Find more posts tagged with

Formulas

Accepted answers

JR90

Hello,

Try this formula out:

=COUNTIFS([Quote Value]:[Quote Value], ISNUMBER(@cell ), [Quote Complete Date]:[Quote Complete Date], IFERROR(YEAR(@cell ), 0) = 2025)@cell

Please let me know if it works!

All comments

JR90

Hello,

Try this formula out:

=COUNTIFS([Quote Value]:[Quote Value], ISNUMBER(@cell ), [Quote Complete Date]:[Quote Complete Date], IFERROR(YEAR(@cell ), 0) = 2025)@cell

Please let me know if it works!

Beth 630

@JR90 Thank you so much! I appreciate you taking the time to look at this!

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.