COUNTIFS matches within a date range between 2 sheets

I have 2 different sheets, both with the same column name.

What formula would I use to be able to get a total number of matches between the 2 sheets within that column, but also only in 2023?

I use this to get the total within the date range, but how would I get a count of the number of matches between the column on 1 sheet and the column on the other sheet?

=COUNTIF([Date Complete]:[Date Complete], IFERROR(YEAR(@cell), 0) = 2023)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!