Testing for the presence of text in a range of cells

Bill Golden
Bill Golden used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi,

You can try:
=IF((SUMPRODUCT(--(B289:F308<>""))=0)=TRUE,0,AA244+1)
Bill GoldenExecutive Managing Member

Author

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

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial