Previous Topic Next Topic

Excel adding a numeric value to mutiple text

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

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

Similar discussions

How to add a contact on WhatsApp
diverdave -
HelpiOS -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses
how to convert Date into text.
rk gupta -
TrowaD -

1 response