CountIFs - 2 Critieria in another referenced sheet

Kiye

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)))

Victoria_Indimar

How about this?

=COUNTIFS ({{Sheet 1: LOCATION}, LOCATION@row, {Sheet 1: YEAR}, NOT(ISBLANK(@cell)))

Victoria_Indimar

How about this?

=COUNTIFS ({{Sheet 1: LOCATION}, LOCATION@row, {Sheet 1: YEAR}, NOT(ISBLANK(@cell)))

Kiye

https://community.smartsheet.com/discussion/comment/363648#Comment_363648

THANK YOU! That works! :)