Select and Sum

[apw420]

I have a row of data - it's broken down in columns by date, and 3 data groups...
How can I do a sum at the end of the row for each data group?

For example...
Oct 1 Oct 2 Oct 3
A B C A B C A B C
1 3 4 2 5 5 7 7 4

How can I sum just A, just B, or just C at the end of the row?

 

[Aladin Akyurek]

On 2002-10-22 14:40, apw420 wrote:
I have a row of data - it's broken down in columns by date, and 3 data groups...
How can I do a sum at the end of the row for each data group?

For example...
Oct 1 Oct 2 Oct 3
A B C A B C A B C
1 3 4 2 5 5 7 7 4

How can I sum just A, just B, or just C at the end of the row?

You didn't specify any ranges...

=SUMPRODUCT(($A$2:$N$2="A")*($A$3:$N$25))

 

[IML]

If you only have one row you need to sum dependant on another row, you could get away with a sumif statement, something along the lines of
=SUMIF(A2:N2,"a",A3:N3)
adjusted to suit your range
This message was edited by IML on 2002-10-22 15:10

 

[apw420]

IML -

That's the stuff.
Thank you.

AW

 

[IML]

Great. Take note for future reference of Aladin's formula. While the sumif would be preferable to
=SUMPRODUCT(($A$2:$C$2="A")*($A$3:$C$3))
his can used on multiple rows, for example,
=SUMPRODUCT(($A$2:$C$2="A")*($A$3:$C$5))
would sum up everything in rows3-5 based on the A being in cell 2