Excel adding a numeric value to mutiple text [Solved/Closed]

Report
Posts
2
Registration date
Monday June 15, 2015
Status
Member
Last seen
June 16, 2015
-
 Blocked Profile -
Hello,
I'm trying to add a value of "1" when a cell contains text "tribal birth" , "midwife", and "hospital birth".

The range of cells with the information is M3:M1138 and I want my results to end up in Q4. Please help! Thank you.

2 replies


Is this homework? We can't help with homework. Let us know what part of =IF(logictest,true,false) you need help with!
Posts
2
Registration date
Monday June 15, 2015
Status
Member
Last seen
June 16, 2015

No this is not homework. I'm accumlating a list in excel for my job. After numerous net searches I was able to figure it out.

Did you understand the if statement I posted previously? Did it apply to your application?

I have said it once, I will say it again. IT!

Thanks Mark. I finally figured it out. Thanks for your help
Blocked Profile
I am sorry that i could not offer any more help. What was your solution?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!