Sum data by date range

[david72]

Hi

I hope someone can help me with a difficult problem. I have a
spreadsheet with the following data below that will eventually have 60
plus depots:



Date Selected Date Cleared Depot Bank $5 $10
$20 Total
21/4/06 Altona ANZ 500
1000 6000 7500
CBA
1500 2000 6000 9500
NAB
500 1000 5000 6500

20/4/06 Penrith ANZ 600
2000 3000 5600
CBA
500 1000 2000 3500
NAB
1000 2000 3000 6000

What I am trying to do is sum this data into another sheet as is below

ANZ CBA NAB WBC

20/4/06 500 1000 2000 3000
21/4/06 1000 2000 3000 4000
22/4/06 3000 4000 5000 6000

What I am requiring is that when data is entered for the date selected
for any depot , the total for that bank goes under that date and
continues and then finishes when the date cleared is entered.
I hope that is clear.

Thanks for your help

 

[Bob Phillips]

I think you need to explain how you get from the data to the results, it is
not obvious where the link is. What do $5, $10,$20 all mean, and where is
the WBC data?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)