I have two formulas that are fairly identical but one is producing a #NO MATCH error.
=COUNTIFS(Shop:Shop,Shop@row,[Review Start Date]:[Review Start Date], YEAR(@cell)= YEAR([Review Start Date]@row))
This works just fine and returns the proper counts. The Shop column is a number/text field - and the Review Start Date is a date field and returns the number of shops with reviews conducted during the year the review is conducted.
=COUNTIFS(District:District, District@row, [Review Start Date]:[Review Start Date], YEAR(@cell) = YEAR([Review Start Date]@row))
The District column is a number/text field and the Review Start Date is the same field from the previous formula - all on the same sheet.
This returns the #NO MATCH error - I have looked through the data, they are populated
The only other difference between the Shop field and District field is that the District Field is a calculated field. I am using the same formula with appropriate column changes for calculating the same thing for Region and Division counts and seeing the same issue….
