Counting multiple columns, per person for not blank

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



Tags:

Answers

  • MedaUser
    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).