Extract Date, and summarize data request

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
 
M

Mike H

Hi,

Where A1 is the date you are looking for

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top