Using "IF"

W

we88y

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!"!
 
N

Niek Otten

Read HELP for the Data>Subtotal command

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
W

ww

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)
 
W

we88y

Thanks for that, but havign just had a quick read i dont think that will help
either. Perhaps a more detailed example will give a clearer picture of what i
am trying to achieve:

I have two columns; NAME and PICK QUANTITY. When a worker finishes what they
are picking they enter there name in the "NAME" column and the total units
they have picked in the "PICK QUANTITY" column. Obviuosly throughout a day
this list would get quite long. In seperate columns i would have the picker
names and the cell adjacent would have a running total which updates the
addition of any new entries in the "pick quantity" column:

NAME PICK QUANTITY

Mr Smith 100 Mr
Smith 150
Mr Jones 20
Mr Jones 20
Mr Bloggs 46
Mr Bloggs 60
Mr Mooney 30 Mr
Mooney 30
Mr Smith 50
Mr Bloggs 14


I hope the example above makes it clearer!!!

Thanks

Andy Webb
 
F

Franz

Hi, I think I have a solution...
Suppose you have "Name" in column A and "Pick qty" in column B. Then you
have again "Name" in column F and "Total qty" in column G. Tou can use this
function from cell G2, assuming you have labels on first row.

=SUMIF($A:$A,F2,$B:$B)

Hoping to be helpful

Bye

Franz
 
Top