# Summing Data by date from different tables

=?Utf-8?B?U2FyYWhiZXRo?=
Guest
Posts: n/a

 21st Jun 2007
I have a worksheet that has 100 tables consisting of dates and injection
rates. The tables do not all start on the same date, but I need to have
totals for each date and I'm not sure how to do this. I've tried a couple
things but nothing is working. My worksheet looks like this:

Well #1 Well #2
Date Injection Date Injection
10/1/2001 1 1/1/2002 0
11/1/2001 2 2/1/2002 1
12/1/2001 3 3/1/2002 4
1/1/2002 4 4/1/2002 3
2/1/2002 5 5/1/2002 0

I have 100 tables like this that each continue on for 50 years and I need to
sum up all the injection data on the same dates, so ultimately I can find the
total injection for the whole field. I've tried SumIf already and I just
can't figure out how to find the injection data from every table. If anyone
has any ideas I'd greatly appreciate it!

=?Utf-8?B?VG9wcGVycw==?=
Guest
Posts: n/a

 21st Jun 2007
What formulae have you tried? what columns is the data in (say for Well #1 &
#2)?

As you have very large volumes (50 years!) maybe a macro is the best
solution. Do want results for every date of the 50 years?

"Sarahbeth" wrote:

> I have a worksheet that has 100 tables consisting of dates and injection
> rates. The tables do not all start on the same date, but I need to have
> totals for each date and I'm not sure how to do this. I've tried a couple
> things but nothing is working. My worksheet looks like this:
>
> Well #1 Well #2
> Date Injection Date Injection
> 10/1/2001 1 1/1/2002 0
> 11/1/2001 2 2/1/2002 1
> 12/1/2001 3 3/1/2002 4
> 1/1/2002 4 4/1/2002 3
> 2/1/2002 5 5/1/2002 0
>
> I have 100 tables like this that each continue on for 50 years and I need to
> sum up all the injection data on the same dates, so ultimately I can find the
> total injection for the whole field. I've tried SumIf already and I just
> can't figure out how to find the injection data from every table. If anyone
> has any ideas I'd greatly appreciate it!

=?Utf-8?B?U2FyYWhiZXRo?=
Guest
Posts: n/a

 21st Jun 2007
Well 1 is takes up columns A and B, the dates in A and injection in B. Well
2 is in D and E, 3 in G and H, and so on. And I do need results for each
date, even if only 1 well has injection for a specific date. I would prefer
to keep it formatted this way instead of starting out at the earliest date
for each well and just entering 0 for the injection. If I do it that way I
will have to reformat my whole worksheet and since there are 100 of them I'd
like to avoid that! I haven't used macros ever though so I wouldn't know how
to start recording one and get it to do what I want.

"Toppers" wrote:

> What formulae have you tried? what columns is the data in (say for Well #1 &
> #2)?
>
> As you have very large volumes (50 years!) maybe a macro is the best
> solution. Do want results for every date of the 50 years?
>
> "Sarahbeth" wrote:
>
> > I have a worksheet that has 100 tables consisting of dates and injection
> > rates. The tables do not all start on the same date, but I need to have
> > totals for each date and I'm not sure how to do this. I've tried a couple
> > things but nothing is working. My worksheet looks like this:
> >
> > Well #1 Well #2
> > Date Injection Date Injection
> > 10/1/2001 1 1/1/2002 0
> > 11/1/2001 2 2/1/2002 1
> > 12/1/2001 3 3/1/2002 4
> > 1/1/2002 4 4/1/2002 3
> > 2/1/2002 5 5/1/2002 0
> >
> > I have 100 tables like this that each continue on for 50 years and I need to
> > sum up all the injection data on the same dates, so ultimately I can find the
> > total injection for the whole field. I've tried SumIf already and I just
> > can't figure out how to find the injection data from every table. If anyone
> > has any ideas I'd greatly appreciate it!

=?Utf-8?B?VG9wcGVycw==?=
Guest
Posts: n/a

 22nd Jun 2007
Can you send me your worksheet (or a reasonable sample) with expected output:
I have written a macro but would like to test it on "live" data.

toppers <at> johntopley.fsnet.co.uk

"Sarahbeth" wrote:

> I have a worksheet that has 100 tables consisting of dates and injection
> rates. The tables do not all start on the same date, but I need to have
> totals for each date and I'm not sure how to do this. I've tried a couple
> things but nothing is working. My worksheet looks like this:
>
> Well #1 Well #2
> Date Injection Date Injection
> 10/1/2001 1 1/1/2002 0
> 11/1/2001 2 2/1/2002 1
> 12/1/2001 3 3/1/2002 4
> 1/1/2002 4 4/1/2002 3
> 2/1/2002 5 5/1/2002 0
>
> I have 100 tables like this that each continue on for 50 years and I need to
> sum up all the injection data on the same dates, so ultimately I can find the
> total injection for the whole field. I've tried SumIf already and I just
> can't figure out how to find the injection data from every table. If anyone
> has any ideas I'd greatly appreciate it!

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post doofy Microsoft Excel Misc 15 18th Jul 2007 08:52 AM doofy Microsoft Excel Worksheet Functions 15 18th Jul 2007 08:52 AM =?Utf-8?B?fipBbWFuZGEqfg==?= Microsoft Excel Misc 1 14th Mar 2007 08:35 PM Mike Saifie Microsoft Access Form Coding 1 9th Mar 2006 02:08 AM =?Utf-8?B?UmV2?= Microsoft Access Forms 1 15th Dec 2004 03:15 PM

Features