Help please!

Beth 630

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!

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!

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!