an interesting problem

[question]

currently i am working on a project in excel, and I need some help on creating a formula. this is the info.

A B C
_________
1|R G 20
2|S T 5
3|R T 7
4|S G 87
5|R G 8
6|R T 9

I need a sumif function that will allow me to add values in column c, that have a column a & b corresponding to RG. In the info above, the cell with the formula should have a value of 28. Unfortunatly I can't find a single line formula to do this. The only other way I've found to do it so far makes me input around 5200 formuli (81 rows by 64 columns + extras). Obviously this is not an option. So if anything can be done about this, i would be most appreciative.

[Jay Petrulis]

On 2002-05-20 07:44, question wrote:
currently i am working on a project in excel, and I need some help on creating a formula. this is the info.

A B C
_________
1|R G 20
2|S T 5
3|R T 7
4|S G 87
5|R G 8
6|R T 9

I need a sumif function that will allow me to add values in column c, that have a column a & b corresponding to RG. In the info above, the cell with the formula should have a value of 28. Unfortunatly I can't find a single line formula to do this. The only other way I've found to do it so far makes me input around 5200 formuli (81 rows by 64 columns + extras). Obviously this is not an option. So if anything can be done about this, i would be most appreciative.

Try

=SUMPRODUCT((A1:A10="R")*(B1:B10="G")*(C1:C10))

Change the ranges to match your data.

Bye,
Jay

[Aladin Akyurek]

On 2002-05-20 07:44, question wrote:
currently i am working on a project in excel, and I need some help on creating a formula. this is the info.

A B C
_________
1|R G 20
2|S T 5
3|R T 7
4|S G 87
5|R G 8
6|R T 9

I need a sumif function that will allow me to add values in column c, that have a column a & b corresponding to RG. In the info above, the cell with the formula should have a value of 28. Unfortunatly I can't find a single line formula to do this. The only other way I've found to do it so far makes me input around 5200 formuli (81 rows by 64 columns + extras). Obviously this is not an option. So if anything can be done about this, i would be most appreciative.

=SUMPRODUCT((A1:A6&B1:B6=E1)*(C1:C6))

where E1 houses a value like RG, a concatenated condition.

Aladin