Countifs with specific criteria for month & year

Kateshev

Hi All,

Im a new smartsheet user and trying to complete a formula to count how many entries are in a specific month and year. I.e Entry relating to 'VIC" submitted in 'Oct' '2022' (pulling from another sheet)

I have been using the Countifs function:

=Countifs({SHEET Range 1}, "VIC", {SHEET Range 2}, "Month(10)", {SHEET Range 2}, "YEAR(2022)")

I believe i need to also use the IFERROR function as there will be fields with no dates yet.

I am getting a return of 0 everytime, but know there are entries there.

Any suggestions please? Thank you!

Paul Newcome

Try this:

=Countifs({SHEET Range 1}, "VIC", {SHEET Range 2}, AND(IFERROR(MONTH(@cell), 0) = 10, IFERROR(YEAR(@cell), 0) = 2022))