I want to do a MAX value for the latest date in my data for the "Actual" column, but, say that one cell has no date, I want the MAX (in yellow) to be blank too. Any help would be appreciated!
Data from Table Image:
I suggest the following formula, assuming that the "Actual" column is C:
=IF(COUNTBLANK(C2:C8)=0,MAX(C2:C8),"")
Or more general:
=IF(COUNTBLANK(range)=0,MAX(range),"")
You may use any of these also:
=IF(SUMPRODUCT(--(C2:C8=""))>0,"",MAX(C2:C85))
or
=IF(COUNTIF(C2:C8,"")>0,"",MAX(C2:C8))
N.B. Adjust cell references as needed.