One Cell/Two Different Columns

[something68]

Please see "chart", specifically "Columns A, M, and O"

Column M adds Columns A, B, C, E, and G
Column O adds Columns A, D, and F

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.00
23.00

 

[Luke M]

Column M: (looking for "A")
=SUMPRODUCT(--ISNUMBER(SEARCH("A",$A$8:$G$8)),$A$9:$G$9)
Column N: (looking for "S")
=SUMPRODUCT(--ISNUMBER(SEARCH("S",$A$8:$G$8)),$A$9:$G$9)

 

[something68]

I'm afraid it did not add/total the row of "A" only (in column m) or the row
of "s" (in column o)...