year to date report help needed.

[Tacknow]

I need help with a year to date report.

I have a list of customers who are supplied with chemicals through out the year.

I need to generate a report of the amount of chemicals delivered to each site year to date. Some sites will have multiply deliveries, so these deliveries need to be combined.

Please see the attached Excel report. Sheet one contains the master data, sheet two is an example of how I would like the report might look.

If you can help I would appreciate it greatly.

Thanks in advance