Countifs with specific criteria for month & year

edited 11/30/22 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!