Sign up, and you can make all message times appear in your timezone. Sign up
Jul 30, 2014
12:58:21pm
RE: Excel Question
Yes. The 's' numbers are easier to add. Assuming those 3 value sets are in A1, B1, and C1, the formula would be the following for the 's' sum:

=LEFT(A1,1)+LEFT(B1,1)+LEFT(C1,1)

For the 'n' sum:

=MID(A1,4,1)+MID(B1,4,1)+MID(C1,4,1)

CAVEAT: This is assuming the digits are always one digit and not two-digits, such as '10' or '15'. If you need to handle two or more digits:

For the 's' sum:

=LEFT(A1,(FIND("s",A1)-1))+LEFT(B1,(FIND("s",B1)-1))+LEFT(C1,(FIND("s",C1)-1))

For the 'n' sum:

=MID(A1,FIND(",",A1)+1,((LEN(A1)-1)-FIND(",",A1)))+MID(B1,FIND(",",B1)+1,((LEN(B1)-1)-FIND(",",B1)))+MID(C1,FIND(",",C1)+1,((LEN(C1)-1)-FIND(",",C1)))

That gets kind of hairy, as you see but it can be done. The other option is to run a TEXT to COLUMNS on the cells and split on the comma as the delimiter. This will separate the two and then you can use the solution for the 's' sum for both.
caillou
New username
FleaFlicker
Bio page
caillou
Joined
May 23, 2014
Last login
Jul 30, 2014
Total posts
0 (0 FO)
Messages
Author
Time

Posting on CougarBoard

In order to post, you will need to either sign up or log in.