CountIfs with year-function over reference cloumn

KROnline

Hello,

I'm using the countifs function over a cross reference to another sheet with several counts very well.

But now I want to count, if a date in a reference sheet is in the current year. And I don't want to use a seprate column, where I have only the year.

So I tried the following:

=COUNTIFS(YEAR{Refererence}), 2022) where reference is the column of another sheet with the date I want to check.

So my question is about how to use function on a reference column

Thanks

Kay

Paul Newcome

You would use this:

=COUNTIFS({Reference}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())

=COUNTIFS({Reference}, IFERROR(YEAR(@cell), 0) = 2022)

KROnline

Thanks Paul, that's what I was looking for !!!!

Paul Newcome

You would use this:

=COUNTIFS({Reference}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())

=COUNTIFS({Reference}, IFERROR(YEAR(@cell), 0) = 2022)

KROnline

Thanks Paul, that's what I was looking for !!!!

Paul Newcome

Happy to help. 👍️