Avatar of Bill Golden
Bill Golden
Flag 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:
=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?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Shums Faruk

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bill Golden

ASKER
Worked Perfectly! Thanks.
Shums Faruk

You're Welcome Bill! Glad I was able to help.
Your help has saved me hundreds of hours of internet surfing.
fblack61