Filter & Total YTD

Amanda Rhodes

Hello,

I'm trying to filter how many YTD programs I've held of a specific program. There is a column with many program names, and a column with Start Dates. How do I find the YTD total of a specific program? This is what I've come up with so far, but it keeps giving me errors.

=COUNTIFS({Program Name Column In reference sheet}, "Program Name", <YEAR(TODAY())

Thanks!

Paul Newcome

Try...

=COUNTIFS({Program Name Column}, "Program Name", {Date Column}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Amanda Rhodes

It worked! Thank you so much!!

Paul Newcome

Try...

=COUNTIFS({Program Name Column}, "Program Name", {Date Column}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Amanda Rhodes

It worked! Thank you so much!!

Paul Newcome

Happy to help. 👍️