If Function

[Jen_T]

I was wondering if it is possible to add to this formula, if all cell values
are blank than formula returns, blank.
Current Formula in AB2
=IF(W2="Unknown","Unknown",MAX(X2,SUM(Y2:AA2)))

W2 - this cell may have a text value of "Unknown", if so cell value in AB2
would return "Unknown", if not than look at X2 (numeric) and determines if
that value is greater than the sum of Y2:AA2 (all numeric), and returns which
is greater.

I need to have it return blank of W2 through AA2 have no values.

Thank you in advance.

 

[Teethless mama]

=IF(COUNTA(W2:AA2),IF(W2="Unknown","Unknown",MAX(X2,SUM(Y2:AA2))),"")