Hello,
I'm trying to count the number of locations that have a date in a separate column from a referenced sheet. What I want to do is count the number of locations only if the year column is not blank.
A - 2018
A - 2019
A - 2020
B - 2020
B - " "
C - 2019
C - 2020
C - " "
Results: A - 3 , B - 0, and C - 2
My current sheet has a list of all the locations.
What I've Tried: =COUNTIFS ({{Sheet 1: LOCATION}, LOCATION@row, {Sheet 1: YEAR}, AND(@cell = NOT(ISBLANK)))
