Extract Date, and summarize data request

  • Thread starter Thread starter joecrabtree
  • Start date Start date
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
 
Hi,

Where A1 is the date you are looking for

=SUMPRODUCT((Data!A2:A40=A1)*(Data!C2:C40))

Mike
 
Back
Top