Two totals in one cell shown in two separate columns

[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)

 

[NBVC]

It is not clear if your A,S is in one cell or in separate cells?


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[Eduardo]

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

 

[NBVC]

If your data is in separate columns.. e.g A:L

then use these:

=Countif(A8:L8,"A")

and

=Sumif(A8:L8,"S",A9:L9

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[something68]

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"

 

[Eduardo]

Hi,
so you are saying you have A and S in one cell which is B3 and 1, 5 in cell
B4,

 

[something68]

That is correct

Hi,
so you are saying you have A and S in one cell which is B3 and 1, 5 in cell
B4,

 

[NBVC]

How are values separated in the cells?

Also, are the choices only A and S and is A always first numbers, and S
is always second numbers?


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[something68]

Separated by a comma, A, S.

Right now, A & S are the choices and I will always use "A" first.

 

[Pete_UK]

This is a bit different than your other post, but check that out as
well for the answers there.

Pete