you may have to insert two new columns next to column A (so you now have two
new blank columns B & C)

enter the below formulas
B8
=LEFT(A8,1)

C8
=RIGHT(A8,1)

B9
=VALUE(LEFT(A9,FIND(",",A9)-1))

C9
=VALUE(RIGHT(A9,LEN(A9)-FIND(",",A9)))


and in your Column M (which is now Column O as we inserted two new columns)
=SUMIF(B8:I9,"=A",B9:I9)

and in your Column O (which is now Column Q as we inserted two new columns)
=SUMIF(B8:I9,"=S",B9:I9)

Regards,
-kc
*Click YES if this works


"something68" wrote:


ANNUAL SICK
A B C D E F G M
N O
Row 8 A, S A A S A S A
Row 9 1.0, 7.0 8.00 8.00 8.00 8.00 8.00 8.00 33.0
0.0 23.0

As you can see, Cell A9 has two leave "hours"; one for A (1.0) and one for S
(7.0).

I would like:

Colmn M, row 9 to show 33.0 (all of the "hours" related to A from row 8); and
Column O, row 9 to show 23.0 (all of the "hours" related to S from row 8)