We help IT Professionals succeed at work.

Testing for the presence of text in a range of cells

57 Views
Last Modified: 2017-03-21
I need to test for the presence of text in a range of cells.
I have the following formula:
=IF(B289="",0,SUM(AA244+1))
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?
Comment
Watch Question

Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Bill GoldenExecutive Managing Member

Author

Commented:
Worked Perfectly! Thanks.
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
You're Welcome Bill! Glad I was able to help.