Total Different Cells

  • Thread starter Thread starter Harry's GMail World
  • Start date Start date
H

Harry's GMail World

I have a list of cells in two rows:

Harry 40
John 41
Harry 13
Bob 20
John 23
Bob 23

I need to extract the total of each person and enter in another TWO
rows by name and amount. Only one name for each person will appear.

As:
Harry 53
John 64
Bob 43

NOTE:--Alpha'd if possible.

Thanks.

Etc.
 
Select the name range (not the numbers) including a header, if there is no
header create one.
Then apply data>filter>advanced filter, select copy to another location and
unique records only. If you copy the filtered rang to let's say H1 you will
get a header in H1 and a unique name list below. No in I2 put

=SUMIF($A$2:$A$50,H2,$B$2:$B$50) (where A2 is the first cell with names in
your original list with names and numbers)

copy down as long as needed
 
Hi,

Presuming the names are in the first column, and the amounts in the second,
and you wish for instance to have the aggregated data in the 4th and 5th
column:

First insert a title row on top of your data and specify for instance "Name"
on top of the first column and "Amount" on top of the second.
Select both columns, then Use >Data >Pivot Table, accept the range of the 2
columns, then specify that you wish to postion the results from cell D1
onwards (provided you don't have any data there, otherwise you could also
present the results in a different sheet.
Then, add the "Name" variable to the "row" area, and the "Amount" variable
to the "Data" area. As a result you will have the table you wish in a nice
format...

Hope this helps,
Erny
 
Hi,

Presuming the names are in the first column, and the amounts in the second,
and you wish for instance to have the aggregated data in the 4th and 5th
column:

First insert a title row on top of your data and specify for instance "Name"
on top of the first column and "Amount" on top of the second.
Select both columns, then Use >Data >Pivot Table, accept the range of the 2
columns, then specify that you wish to postion the results from cell D1
onwards (provided you don't have any data there, otherwise you could also
present the results in adifferentsheet.
Then, add the "Name" variable to the "row" area, and the "Amount" variable
to the "Data" area. As a result you will have the table you wish in a nice
format...

Hope this helps,
Erny









- Show quoted text -
Click to expand...

Thanks...it works. Now, I have to figure out which answer suits my
problem.
 
Hi,

Presuming the names are in the first column, and the amounts in the second,
and you wish for instance to have the aggregated data in the 4th and 5th
column:

First insert a title row on top of your data and specify for instance "Name"
on top of the first column and "Amount" on top of the second.
Select both columns, then Use >Data >Pivot Table, accept the range of the 2
columns, then specify that you wish to postion the results from cell D1
onwards (provided you don't have any data there, otherwise you could also
present the results in adifferentsheet.
Then, add the "Name" variable to the "row" area, and the "Amount" variable
to the "Data" area. As a result you will have the table you wish in a nice
format...

Hope this helps,
Erny









- Show quoted text -
Click to expand...


Thanks..it works. Now I have to figure out which of the two solutions
fit my problem.
This is a great place (with brains to match) to get answers.
 
Back
Top