2 columns

[ahmed hassaan]

i have 3 columns
code name data
9 pok 200
8 okl 50
9 lok 200
5 pok 140
8 rok 852
9 pok 741
2 kil 25
9 rok 785

i want to sum by code & name(both same)
means
9 pok 200
9 pok 741

which formula is correct for?

 

[Claus Busch]

Hi Ahmed,

Am Fri, 18 May 2012 10:36:02 GMT schrieb ahmed hassaan:

i have 3 columns
code name data
9 pok 200
8 okl 50
9 lok 200
5 pok 140
8 rok 852
9 pok 741
2 kil 25
9 rok 785

i want to sum by code & name(both same)
means
9 pok 200
9 pok 741

try:
=SUMPRODUCT(--(A2:A100=9),--(B2:B100="pok"),C2:C100)
or
=SUMPRODUCT((A2:A100=9)*(B2:B100="pok")*C2:C100)


Regards
Claus Busch

 

[Claus Busch]

Hi Ahmed,

if you have xl2007 or xl2010 you can also try:
=SUMIFS(C:C,A:A,9,B:B,"pok")


Regards
Claus Busch