Thread: Using "IF"
View Single Post
  #3   Report Post  
ww
 
Posts: n/a
Default

You could use a sumif() if you are looking for a specific name. If the names
are in column A and the numbers are in Column B in a seperate cell use
=sumif(A1:A100,"bob",B1:B100)


"we88y" wrote:

for example i have a column with names in and another column with numbers in.
I want, in a seperate cell, to search the name column and if there are
duplicates of a name to add the numbers up in the corresponding cells. Is
this possible...HELP!"!