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
-
Are you able to provide some screenshots for context?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!