Help w/COUNTIFS, UNIQUE and specific year

jmo

Hi team - I have a sheet with a column called "Agreement Number" that I normally look down to get a unique count of agreements using: =COUNT(DISTINCT({(Source Data) Agreement number}))

I now have data that I've placed in that sheet in 2020 and 2021. What I'd like to do is count the unique agreements in the "Agreement number" column that were created in 2021. Created is an auto generated date.

Any ideas on how to go about that?

Paul Newcome

Try something like this...

=COUNT(DISTINCT(COLLECT({(Source Data) Agreement number}, {Created Date Column}, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2021)))

Paul Newcome

Try something like this...

=COUNT(DISTINCT(COLLECT({(Source Data) Agreement number}, {Created Date Column}, IFERROR(YEAR(DATEONLY(@cell)), 0) = 2021)))

jmo

That worked! Thanks so much @Paul Newcome !!!