Text string and sum
Hi!
One way:
Enter this formula in say, E1:
=ROWS($1:1)-1
Enter this formula in F1:
=SUMIF(A$1:A$6,"*"&E1&"*",B$1:B$6)
Select both E1 and F1 and copy down to row 10.
Biff
"michaelp" wrote in message
...
Good Afternoon
I have 2 columns one with a string of numbers and the other a number
1,-,-,-,-,-,-,-,-,- 247
-,2,-,-,-,-,-,-,-,- 34
-,-,3,-,-,-,-,-,-,- 34
-,-,-,4,-,-,-,-,-,- 24
-,-,-,-,5,-,-,-,-,- 2608
-,-,-,-,-,6,-,-,-,- 2
What I want to do is search the range of text string to find lets say
the number 2 (the numbers appear in the same position every time or is
replaces with the - ) then sum the next column that relates to the
number 2 etc
I have 1023 lines of text string (total number of combinations of 10)
Thank you
--
michaelp
|