View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 6
Default Summing the same column from many sheets with specific Row ID numbers

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