Summing the same column from many sheets with specific Row ID numbers
Good deal. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Chris" wrote in message
...
On Nov 7, 1:00 pm, "T. Valko" wrote:
Ooops! Typo in the formula. That's what I get for Copy/pasting!
Correct formula should be:
=SUMIF(Sept08!A$1:A$10,A1,Sept08!B$1:B$10)+SUMIF(A ugust08!A$1:A$10,A1,August08!B$1:B$10)
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
If you only have a "few" sheets...
List the unique codes in the range A1:An
Enter this formula in B1 and copy down as needed:
=SUMIF(Sept08!A$1:A$10,A1,Sept08!B$1:B$10)+SUMIF(A ugust08!A$1:A$10,A1,Sept08!B$1:B$10)
--
Biff
Microsoft Excel MVP
"Chris" wrote in message
...
Hi all,
I've been working on this and can't seem to figure it out.
Here's my data set:
Sept08!
ID Measures
123 0
345 1
545 2
678 2
567 3
August08!
ID Measures
123 0
345 0
545 3
678 1
567 0
What I want to be able to do is Sum the Measures column in Sept08! and
August08!, on a different sheet so that it corresponds with each ID
number: So the result would look like
ID TotalMeasures
123 0
345 1
545 5
678 3
567 3
Any suggestions?
Thanks!
Chris
Thanks to all, I believe I got it to work out!
|