Two totals in one cell shown in two separate columns

  • Thread starter Thread starter something68
  • Start date Start date
S

something68

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)
 
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
 
This is very close. Let me try explaining it this way:

I have "A" in Cell B03, B07, B20, and B21
I have "S" in Cell B03

I have "1.0" in Cell B04, "7.0" in cells B07, B20, and B21
I have "5.0" in Cell B04

I would like Cell M 04 to show "22.0"
I would like Cell R 04 to show "5.0"
 
Separated by a comma, A, S.

Right now, A & S are the choices and I will always use "A" first.
 
This is a bit different than your other post, but check that out as
well for the answers there.

Pete
 
Back
Top