Previous Topic Next Topic

Excel adding a numeric value to mutiple text

Solved/Closed
misscupcake40 Posts 2 Registration date Monday June 15, 2015 Status Member Last seen June 16, 2015 - Jun 15, 2015 at 06:09 PM
 Blocked Profile - Jun 24, 2015 at 06:34 PM
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.
Related:

2 responses

Answer 1 / 2
Blocked Profile
Jun 15, 2015 at 07:19 PM
Is this homework? We can't help with homework. Let us know what part of =IF(logictest,true,false) you need help with!
0
misscupcake40 Posts 2 Registration date Monday June 15, 2015 Status Member Last seen June 16, 2015
Jun 16, 2015 at 11:08 AM
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.
0
Answer 2 / 2
Blocked Profile
Jun 19, 2015 at 07:46 PM
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!
0
misscupcake40
Jun 22, 2015 at 01:57 PM
Thanks Mark. I finally figured it out. Thanks for your help
0
Blocked Profile
Jun 24, 2015 at 06:34 PM
I am sorry that i could not offer any more help. What was your solution?
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses