# Why does the SUM formula not work?

I trust someone can figure out what is causing a simple SUM statement to fail.  My suspicion is that it has something to do with the values being generated in cells DI11 through DX65.
First, I am trying to use the following formula to test for multiple conditions.
=IF(OR(ISTEXT(B11)=TRUE, ISTEXT(C11)=TRUE, ISTEXT(D11)=TRUE, ISTEXT(E11)=TRUE, ISTEXT(F11)=TRUE), "1", "0")
If any of the cells referenced in the formula are true, I want a one (1) in the cell.  If any of the cells referenced in the formula are false, I want a zero (0) in the cell.
While the formula seems to work the way I want it, the SUM formula does not total.
What suggestions are there for fixing this anomaly?
Bill aka CowboyWM
Test.xlsm
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Microsoft Excel ExpertCommented:
see it works now.

the problem was when you put the "1" in double qoutes and SUM does not work in text. anything input which is between double qoutes excel considers it as text not a number.

so i fixed it, now your SUM works.  check the attached file.
Microsoft Excel ExpertCommented:
attachment
Test.xlsm

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Excel VBA DeveloperCommented:
The above formula works, but this could be greatly simplified by using this formula instead (copied down):
DI11: =IF(COUNTA(B11:F11)>0,1,0)
DJ11: =IF(COUNTA(I11:M11)>0,1,0)
..and so on for the remaining columns.

I've attached a modified version of your workbook with all these formulas updated.

Regards,
-Glenn
EE-Test-mod.xlsm
Author Commented:
Long hours causes errors not easily seen.  A second pair of eyes is just what I was looking for.  Thank you for pointing out my oversight.

Bill aka CowboyWM
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.