Two totals in one cell shown in two separate columns
 

Column A, row 8 shows: A, S
Column A, row 9 show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (total of all "A" shown in row 8)
I would like Column O, row 9 to show: 7 (total of all "S" shown in row 8)

Two totals in one cell shown in two separate columns
 

Hi,
I assume your information is from column A to L change it to fit your needs

in column M enter

=SUMPRODUCT(--(A8:L8="A"),A9:L9)

in column O enter

=SUMPRODUCT(--(A8:L8="S"),A9:L9)

if this helps please click yes, thanks

"something68" wrote:

Column A, row 8 shows: A, S
Column A, row 9 show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (total of all "A" shown in row 8)
I would like Column O, row 9 to show: 7 (total of all "S" shown in row 8)