Date Lookup and Data Collections

[YorkeG]

Afternoon,

I am looking for a spreadsheet that can allows me to enter in order amounts and pull out daily totals into a chart.

On the Tuesday to Friday sheets of the attached file, I would like to be able to enter different sales orders into the chart, so I can see a daily total of sales through out the month. This means I need a formula to go into the Monthly Data sheet that will pull out the totals for the matching dates.

For example, if I entered in sales orders in the Tuesday sheet, the B4 cell in the Monthly Data sheet would read the total amount in H33 of the Tuesday sheet.

I need to know the formula that will do this.

Hope this makes sense. Contact me if you need clarification.

Yorke