SUMMING COLUMNS IN DIFFERENT WORKSHEETS

P

Peggy

2 worksheets
Worksheet 1 has a column with 100 names, with duplicates . In the cell
next to each name are numbers, with some blank cells.

In worksheet 2, I have all the previous names, but no duplicates. I want to
reference worksheet 1, looking for a name and then summing all the values
attached to that name. I don't want to count the names, but add the values
each time the name appears

Thank you for any help you can give me.
 
M

Max

Assume in Sheet1, names are in col A, numbers in col B, data from row1 down

In Sheet2, assume the "previous names" are in col A, in A2 down

Put in B2: =SUMIF(Sheet1!A:A,A2,Sheet1!B:B)
Copy B2 down

Col B should return the desired results
 
S

sam_360

:) I don't know if this is related, but I want a sheet of totals, how do
I get a cell in sheet 4 to = a cell in sheet 2?
:)
 
M

Max

....
:) I don't know if this is related, but I want a sheet of totals,
how do I get a cell in sheet 4 to = a cell in sheet 2?
Click to expand...

Probably not related to the orig. post
But for the question you're raising above, perhaps ..

In Sheet4,
Put in say, A2: =Sheet2!A2
This will link Sheet4's A2 to Sheet2's A2
The contents in Sheet2's A2 will be reproduced in Sheet4's A2
 
Top