Sum data by date range
 

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


--
david72
------------------------------------------------------------------------
david72's Profile: http://www.excelforum.com/member.php...fo&userid=7980
View this thread: http://www.excelforum.com/showthread...hreadid=535383

Sum data by date range
 

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)

"david72" wrote in
message ...

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


--
david72
------------------------------------------------------------------------
david72's Profile:
http://www.excelforum.com/member.php...fo&userid=7980
View this thread: http://www.excelforum.com/showthread...hreadid=535383