Sum
in [General]
|
From: Rod on 4 Jan 2010 10:32 Hi, I have data as shown below. Col-A Col-B Col-C Col-D a 10 b b 15 d c 20 d 25 e 30 I need the sum of "b" and "d" values(15+25) in column D1(40). If I add the any letter of Col-A in column c it will automatically update the value in D1. Could any one help me please. Thanks in advance.
From: Bernard Liengme on 4 Jan 2010 10:51 =SUMIF(A:A,C1,B:B) assuming cell C1 holds the value b best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Rod" <Rod(a)discussions.microsoft.com> wrote in message news:D68E252D-EF7E-439E-A798-03D937EB482F(a)microsoft.com... > Hi, I have data as shown below. > Col-A Col-B Col-C Col-D > a 10 b > b 15 d > c 20 > d 25 > e 30 > I need the sum of "b" and "d" values(15+25) in column D1(40). If I add the > any letter of Col-A in column c it will automatically update the value in > D1. > Could any one help me please. Thanks in advance.
From: Eduardo on 4 Jan 2010 10:57 Hi, in D1 enter =sumproduct(--(C1=$a$1:$A$1000),$B$1:$B$1000) change range to fit your needs "Rod" wrote: > Hi, I have data as shown below. > Col-A Col-B Col-C Col-D > a 10 b > b 15 d > c 20 > d 25 > e 30 > I need the sum of "b" and "d" values(15+25) in column D1(40). If I add the > any letter of Col-A in column c it will automatically update the value in D1. > Could any one help me please. Thanks in advance.
From: Max on 4 Jan 2010 11:08 In D1: =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A10,C1:C2,0))),B1:B10) where C1:C2 houses the elements, eg: b, d (as you posted) Success? hit the YES below -- Max Singapore --- "Rod" wrote: > Hi, I have data as shown below. > Col-A Col-B Col-C Col-D > a 10 b > b 15 d > c 20 > d 25 > e 30 > I need the sum of "b" and "d" values(15+25) in column D1(40). If I add the > any letter of Col-A in column c it will automatically update the value in D1. > Could any one help me please. Thanks in advance.
From: Rod on 4 Jan 2010 11:17
Thanks for quick response, when I enter this formula in D1 i am getting just 15 only "Eduardo" wrote: > Hi, > in D1 enter > =sumproduct(--(C1=$a$1:$A$1000),$B$1:$B$1000) > > change range to fit your needs > > "Rod" wrote: > > > Hi, I have data as shown below. > > Col-A Col-B Col-C Col-D > > a 10 b > > b 15 d > > c 20 > > d 25 > > e 30 > > I need the sum of "b" and "d" values(15+25) in column D1(40). If I add the > > any letter of Col-A in column c it will automatically update the value in D1. > > Could any one help me please. Thanks in advance. |