Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

asked on

Testing for the presence of text in a range of cells

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?
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Golden


Worked Perfectly! Thanks.
You're Welcome Bill! Glad I was able to help.