Adding values

[CrashMatRob]

I have a spreadsheet with one column of names
the names are repeated down
column :A Colum
rob 5
rob 2
martin 5
rob 6
martin 5
etc:
in another column D I have values of numbers

Is it possible to add up all the values in column D associated with Rob

i.e. Rob =13
Martin =10

Thanks Rob

 

[Don Guillett]

Look in the help index for
SUMIF

 

[CurlyDave]

Try SumIf()
=SUMIF($A$1:$A$5,"rob",$D$1:$D$5)

 

[CrashMatRob]

Thanks allot worked a treat

Rob

 

[Don Guillett]

Glad to help you help yourself

 

[xlmate]

try

=SUMIF(A:A,"Rob",B:B) or

better to use cell to hold the criteria,
eg. type the name "Rob" in C2 without the quotation mark.

=SUMIF(A:A,C2,B:B)

--
HTH

Pls provide your feedback by clicking the YES button below if this posting
is helpful
This will help others to search the results in the archive better

cheers, francis