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)
Help Article Resources
Check out the Formula Handbook template!