Hi Aboo and welcome to the forum. 
Im pretty new to Excel so please bare with me.
An unfortunate typo there...
Please can someone give me some ideas or point me in the right direction.
Sure, I'll tell you how I'd do it: using a pivot table.
I would change the layout of the data so that a column contains the date that each person bought the fruit, like this:
You just keep adding to the list as the weeks pass by.
I would then create a pivot table using this as a data source.
In the row fields I would put in the Date and then the Person.
In the column fields I would then put in each of the fruits and set each of the fields to return the sum (ie. the quantity).
On the Date row field, I would right click > group > and then I would set the Starting Date as the beginning of the earlist week and group by Days with a Day count of 7. This will group all of the numbers into weeks.
To include the weekly invoice amounts you could either create calculated fields within the pivot table or, for more flexibility, you could add additional columns to your table which calculate the invoice amounts and include those columns within your pivot table's source range.
Hope that gives you some ideas.
Bookmarks