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

Read HELP for the DataSubtotal command

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"we88y" wrote in message
...
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!"!

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

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


"Niek Otten" wrote:

Read HELP for the DataSubtotal command

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"we88y" wrote in message
...
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!"!

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

"we88y" ha scritto nel messaggio
...
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


"Niek Otten" wrote:

Read HELP for the DataSubtotal command

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"we88y" wrote in message
...
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!"!