sumif?

P

PeCoNe

I need to sum the Ax fields if the name in column D is the same as the
name in D1 and place the total in a1.

I think it is SUMIF but how?




0 RD


V/W ---------- Type Effect ----------
abs % # Fonds
17.98 0.44%

3.05 2.96% 1 AGN
-12.95 -80.94% -1 AGN
52.73 2.09% 100 RD
-51.95 -31.30% 1 RD
55.00 4.61% 100 SBM
-27.90 -32.84% 1 SBM

Thanks Peter
 
C

Claus Busch

Hi Peter,

Am Thu, 25 Apr 2013 20:01:26 +0200 schrieb PeCoNe:
I need to sum the Ax fields if the name in column D is the same as the
name in D1 and place the total in a1.
Click to expand...

try:
=SUMIF(D5:D100,D1,A5:A100)


Regards
Claus Busch
 
Top