SUMMING COLUMNS IN DIFFERENT WORKSHEETS
 

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.

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Peggy" wrote in message
...
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.

:) 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?
:)


--
sam_360
------------------------------------------------------------------------
sam_360's Profile: http://www.excelforum.com/member.php...o&userid=24516
View this thread: http://www.excelforum.com/showthread...hreadid=381071

"sam_360" wrote
....
:) 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?

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----