CountIFS with date.

Saj

Hi All,

Need help in below formula as am trying to get project list from year 2024 to date. No error but not giving me the correct results.

=COUNTIFS({Completed Range 1}, $Label@row, {Completed Range 2}, "NPD$1", {Completed Range 3}, YEAR(@cell) >= 2024)

Thanks in advance.

Gia Thinh

Hi @Saj

COUNTIFS returns a specific counting number, not a list.

You may want to try COLLECT function that return a list/range and is used within another function. For example, try this one:

=JOIN(COLLECT({Your Project List Range}, {Completed Range 1}, $Label@row, {Completed Range 2}, "NPD$1", {Completed Range 3}, YEAR(@cell) >= 2024))

Gia Thinh

Hi @Saj

COUNTIFS returns a specific counting number, not a list.

You may want to try COLLECT function that return a list/range and is used within another function. For example, try this one:

=JOIN(COLLECT({Your Project List Range}, {Completed Range 1}, $Label@row, {Completed Range 2}, "NPD$1", {Completed Range 3}, YEAR(@cell) >= 2024))