J
joecrabtree
To all,
I have a spreadsheet with two worksheets. One named 'Data' and the
other one named 'Summary'. In the data worksheet there are 3 columns:
Date Description Price
18/01/09 xxx 66
18/01/09 xxx 88
19/01/09 xxx 99
etc....
Lets say that today's date is 19/01/09. I want to be able to add all
of the information up per day and display it in the summary
worksheet.
For example the out put would look like:
18/01/09 - total amount = 154
19/01/09 - total amount = 99
and so on. This could be potentially for an unlimited range of dates.
Any help you could give would be much appreictaed
Thanks in advance,
Joe
I have a spreadsheet with two worksheets. One named 'Data' and the
other one named 'Summary'. In the data worksheet there are 3 columns:
Date Description Price
18/01/09 xxx 66
18/01/09 xxx 88
19/01/09 xxx 99
etc....
Lets say that today's date is 19/01/09. I want to be able to add all
of the information up per day and display it in the summary
worksheet.
For example the out put would look like:
18/01/09 - total amount = 154
19/01/09 - total amount = 99
and so on. This could be potentially for an unlimited range of dates.
Any help you could give would be much appreictaed
Thanks in advance,
Joe