Counting multiple columns, per person for not blank

Elizabeth Aird

I know this should be easier than I am making it but.. I need to count per person, the number of columns with dates OR the number for not blank divided by 2.

Help please :)

MedaUser

Try this:

=COUNTIF(Entry@row:[Foreman C/Q]@row, "")+COUNTIF(Entry@row:[Foreman C/Q]@row, IFERROR(YEAR(@cell), 0) > 2000)

FYI - First COUNTIF should calculate blanks while the second COUNTIF should calculate cells with a year greater than 2000 (kinda of a workaround to try and recognize a date value).