Trying to sum a column that contains various text
Solved/Closed
chris82675
Posts
3
Registration date
Wednesday January 14, 2015
Status
Member
Last seen
January 15, 2015
-
Jan 14, 2015 at 11:29 AM
chris82675 Posts 3 Registration date Wednesday January 14, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 10:07 AM
chris82675 Posts 3 Registration date Wednesday January 14, 2015 Status Member Last seen January 15, 2015 - Jan 15, 2015 at 10:07 AM
I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then sum the column. For example, column B has 15 rows. Each cell in the column contains various text that reads "BA1,DK1" or "BA2,JN2". Each number after the text would change depending on what row it is in. How would I give a value of "1" to each text of "BA1,DK1,BA2,JN2,etc.." so when I add or remove one from the column my sum reflects the addition or subtraction of said text group?
Related:
- Trying to sum a column that contains various text
- How to delete a column in word - Guide
- Tweetdeck expand column - Guide
- Sum in french excel - Guide
- Excel count occurrences of string in column - Guide
- Sum sum disney - Download - Puzzle
1 response
chris82675
Posts
3
Registration date
Wednesday January 14, 2015
Status
Member
Last seen
January 15, 2015
1
Jan 14, 2015 at 01:12 PM
Jan 14, 2015 at 01:12 PM
OK. After playing around with it I'm most of the way to figuring it out. I gave everything in the cell a value of 1 using the following formula:
=SUMIF(B4:B18,"*",W3:W3)
Now my only problem is if I have more than 1 text string in the same cell. This is an example of what i have:
BA1
JG2
CF3, DK3
DK4, MW4
TO5, DK5
BA10
BA12
BA13
BA14
BA15
I'm getting a sum of 10, but I need to be getting a sum of 13. The DK3, MW4, and DK5 aren't getting assigned a value of 1. The entire cell is just 1. How do I adjust this to get to 13?
=SUMIF(B4:B18,"*",W3:W3)
Now my only problem is if I have more than 1 text string in the same cell. This is an example of what i have:
BA1
JG2
CF3, DK3
DK4, MW4
TO5, DK5
BA10
BA12
BA13
BA14
BA15
I'm getting a sum of 10, but I need to be getting a sum of 13. The DK3, MW4, and DK5 aren't getting assigned a value of 1. The entire cell is just 1. How do I adjust this to get to 13?
Jan 14, 2015 at 05:22 PM
Jan 15, 2015 at 10:07 AM