I need to test for the presence of text in a range of cells.
I have the following formula:
Which works. B289 may or may not contain text. However, I want to return a zero if there is nothing in B289 through F308. I tried:
=IF(B289..F308="",0,SUM(AA244+1)) And got an error!
What am I doing wrong?