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