Rolling Year to Date Figures

J

JamesCES

New Member
Joined
Dec 22, 2016
Messages
15
Hi Guys,

I'm looking for some help with formula's please, We've got a spreadsheet which has our 12 top suppliers at the top and the months below and we put the figures per supplier per month, spreadsheet attached.

I would like the spreadsheet to be able to show us the following
1) Total for the past 12months from today's date (ie whenever we open the spreadsheet it updates based on the date)
2) Yearly Figure for the supplier (Jan to Dec)
4) Would like this to be a rolling so we can keep adding to the bottom of the sheet.
5) Would like to be able to see the best month we've had with that supplier.
6) Grand total for all supplier from the start

Thanks in advance for any suggestions and support that you can provide and hope you all have a nice break and a good new year.
James


<tbody>
[TD="class: xl79, colspan: 2"]NETT SPEND[/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 96"][/TD]
[TD="class: xl71, width: 4"][/TD]
[TD="class: xl71, width: 96"][/TD]

[TD="class: xl84"][/TD]
[TD="class: xl85"]Supplier 1[/TD]
[TD="class: xl85"]Supplier 2[/TD]
[TD="class: xl85"]Supplier 3[/TD]
[TD="class: xl85"]Supplier 4[/TD]
[TD="class: xl85"]Supplier 5[/TD]
[TD="class: xl85"]Supplier 6[/TD]
[TD="class: xl85"]Supplier 7[/TD]
[TD="class: xl85"]Supplier 8[/TD]
[TD="class: xl85"]Supplier 9[/TD]
[TD="class: xl85"]Supplier 10[/TD]
[TD="class: xl85"]Supplier 11[/TD]
[TD="class: xl85"]Supplier 12[/TD]
[TD="class: xl72"][/TD]
[TD="class: xl86"]Monthly Totals[/TD]

[TD="class: xl82"]CREDIT[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"]100[/TD]
[TD="class: xl87"][/TD]
[TD="class: xl73"][/TD]

[TD="class: xl82"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"][/TD]

[TD="class: xl83"]MONTH[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"][/TD]

[TD="class: xl68"]Apr-14[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£20.00[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£22.00[/TD]
[TD="class: xl88"]£33.50[/TD]
[TD="class: xl88"]£20.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£20.00[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£22.00[/TD]
[TD="class: xl88"]£33.50[/TD]
[TD="class: xl88"]£20.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£351.00[/TD]

[TD="class: xl68"]May-14[/TD]
[TD="class: xl88"]£60.00[/TD]
[TD="class: xl88"]£25.00[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£23.00[/TD]
[TD="class: xl88"]£34.50[/TD]
[TD="class: xl88"]£21.00[/TD]
[TD="class: xl88"]£60.00[/TD]
[TD="class: xl88"]£25.00[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£23.00[/TD]
[TD="class: xl88"]£34.50[/TD]
[TD="class: xl88"]£21.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£397.00[/TD]

[TD="class: xl68"]Jun-14[/TD]
[TD="class: xl88"]£70.00[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£24.00[/TD]
[TD="class: xl88"]£35.50[/TD]
[TD="class: xl88"]£22.00[/TD]
[TD="class: xl88"]£70.00[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£24.00[/TD]
[TD="class: xl88"]£35.50[/TD]
[TD="class: xl88"]£22.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£443.00[/TD]

[TD="class: xl68"]Jul-14[/TD]
[TD="class: xl88"]£80.00[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£25.00[/TD]
[TD="class: xl88"]£36.50[/TD]
[TD="class: xl88"]£23.00[/TD]
[TD="class: xl88"]£80.00[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£25.00[/TD]
[TD="class: xl88"]£36.50[/TD]
[TD="class: xl88"]£23.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£489.00[/TD]

[TD="class: xl68"]Aug-14[/TD]
[TD="class: xl88"]£90.00[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£26.00[/TD]
[TD="class: xl88"]£37.50[/TD]
[TD="class: xl88"]£24.00[/TD]
[TD="class: xl88"]£90.00[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£26.00[/TD]
[TD="class: xl88"]£37.50[/TD]
[TD="class: xl88"]£24.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£535.00[/TD]

[TD="class: xl68"]Sep-14[/TD]
[TD="class: xl88"]£100.00[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£55.00[/TD]
[TD="class: xl88"]£27.00[/TD]
[TD="class: xl88"]£38.50[/TD]
[TD="class: xl88"]£25.00[/TD]
[TD="class: xl88"]£100.00[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£55.00[/TD]
[TD="class: xl88"]£27.00[/TD]
[TD="class: xl88"]£38.50[/TD]
[TD="class: xl88"]£25.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£581.00[/TD]

[TD="class: xl68"]Oct-14[/TD]
[TD="class: xl88"]£110.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£60.00[/TD]
[TD="class: xl88"]£28.00[/TD]
[TD="class: xl88"]£39.50[/TD]
[TD="class: xl88"]£26.00[/TD]
[TD="class: xl88"]£110.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£60.00[/TD]
[TD="class: xl88"]£28.00[/TD]
[TD="class: xl88"]£39.50[/TD]
[TD="class: xl88"]£26.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£627.00[/TD]

[TD="class: xl68"]Nov-14[/TD]
[TD="class: xl88"]£120.00[/TD]
[TD="class: xl88"]£55.00[/TD]
[TD="class: xl88"]£65.00[/TD]
[TD="class: xl88"]£29.00[/TD]
[TD="class: xl88"]£40.50[/TD]
[TD="class: xl88"]£27.00[/TD]
[TD="class: xl88"]£120.00[/TD]
[TD="class: xl88"]£55.00[/TD]
[TD="class: xl88"]£65.00[/TD]
[TD="class: xl88"]£29.00[/TD]
[TD="class: xl88"]£40.50[/TD]
[TD="class: xl88"]£27.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£673.00[/TD]

[TD="class: xl68"]Dec-14[/TD]
[TD="class: xl88"]£130.00[/TD]
[TD="class: xl88"]£60.00[/TD]
[TD="class: xl88"]£70.00[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£41.50[/TD]
[TD="class: xl88"]£28.00[/TD]
[TD="class: xl88"]£130.00[/TD]
[TD="class: xl88"]£60.00[/TD]
[TD="class: xl88"]£70.00[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£41.50[/TD]
[TD="class: xl88"]£28.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£719.00[/TD]

[TD="class: xl78"]Jan-15[/TD]
[TD="class: xl88"]£140.00[/TD]
[TD="class: xl88"]£65.00[/TD]
[TD="class: xl88"]£75.00[/TD]
[TD="class: xl88"]£31.00[/TD]
[TD="class: xl88"]£42.50[/TD]
[TD="class: xl88"]£29.00[/TD]
[TD="class: xl88"]£140.00[/TD]
[TD="class: xl88"]£65.00[/TD]
[TD="class: xl88"]£75.00[/TD]
[TD="class: xl88"]£31.00[/TD]
[TD="class: xl88"]£42.50[/TD]
[TD="class: xl88"]£29.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£765.00[/TD]

[TD="class: xl78"]Feb-15[/TD]
[TD="class: xl88"]£150.00[/TD]
[TD="class: xl88"]£70.00[/TD]
[TD="class: xl88"]£80.00[/TD]
[TD="class: xl88"]£32.00[/TD]
[TD="class: xl88"]£43.50[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl88"]£150.00[/TD]
[TD="class: xl88"]£70.00[/TD]
[TD="class: xl88"]£80.00[/TD]
[TD="class: xl88"]£32.00[/TD]
[TD="class: xl88"]£43.50[/TD]
[TD="class: xl88"]£30.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£811.00[/TD]

[TD="class: xl68"]Mar-15[/TD]
[TD="class: xl88"]£160.00[/TD]
[TD="class: xl88"]£75.00[/TD]
[TD="class: xl88"]£85.00[/TD]
[TD="class: xl88"]£33.00[/TD]
[TD="class: xl88"]£44.50[/TD]
[TD="class: xl88"]£31.00[/TD]
[TD="class: xl88"]£160.00[/TD]
[TD="class: xl88"]£75.00[/TD]
[TD="class: xl88"]£85.00[/TD]
[TD="class: xl88"]£33.00[/TD]
[TD="class: xl88"]£44.50[/TD]
[TD="class: xl88"]£31.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£857.00[/TD]

[TD="class: xl68"]Apr-15[/TD]
[TD="class: xl88"]£170.00[/TD]
[TD="class: xl88"]£80.00[/TD]
[TD="class: xl88"]£90.00[/TD]
[TD="class: xl88"]£34.00[/TD]
[TD="class: xl88"]£45.50[/TD]
[TD="class: xl88"]£32.00[/TD]
[TD="class: xl88"]£170.00[/TD]
[TD="class: xl88"]£80.00[/TD]
[TD="class: xl88"]£90.00[/TD]
[TD="class: xl88"]£34.00[/TD]
[TD="class: xl88"]£45.50[/TD]
[TD="class: xl88"]£32.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£903.00[/TD]

[TD="class: xl78"]May-15[/TD]
[TD="class: xl88"]£180.00[/TD]
[TD="class: xl88"]£85.00[/TD]
[TD="class: xl88"]£95.00[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£46.50[/TD]
[TD="class: xl88"]£33.00[/TD]
[TD="class: xl88"]£180.00[/TD]
[TD="class: xl88"]£85.00[/TD]
[TD="class: xl88"]£95.00[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£46.50[/TD]
[TD="class: xl88"]£33.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£949.00[/TD]

[TD="class: xl78"]Jun-15[/TD]
[TD="class: xl88"]£190.00[/TD]
[TD="class: xl88"]£90.00[/TD]
[TD="class: xl88"]£100.00[/TD]
[TD="class: xl88"]£36.00[/TD]
[TD="class: xl88"]£47.50[/TD]
[TD="class: xl88"]£34.00[/TD]
[TD="class: xl88"]£190.00[/TD]
[TD="class: xl88"]£90.00[/TD]
[TD="class: xl88"]£100.00[/TD]
[TD="class: xl88"]£36.00[/TD]
[TD="class: xl88"]£47.50[/TD]
[TD="class: xl88"]£34.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£995.00[/TD]

[TD="class: xl68"]Jul-15[/TD]
[TD="class: xl88"]£200.00[/TD]
[TD="class: xl88"]£95.00[/TD]
[TD="class: xl88"]£105.00[/TD]
[TD="class: xl88"]£37.00[/TD]
[TD="class: xl88"]£48.50[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl88"]£200.00[/TD]
[TD="class: xl88"]£95.00[/TD]
[TD="class: xl88"]£105.00[/TD]
[TD="class: xl88"]£37.00[/TD]
[TD="class: xl88"]£48.50[/TD]
[TD="class: xl88"]£35.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£1,041.00[/TD]

[TD="class: xl68"]Aug-15[/TD]
[TD="class: xl88"]£210.00[/TD]
[TD="class: xl88"]£100.00[/TD]
[TD="class: xl88"]£110.00[/TD]
[TD="class: xl88"]£38.00[/TD]
[TD="class: xl88"]£49.50[/TD]
[TD="class: xl88"]£36.00[/TD]
[TD="class: xl88"]£210.00[/TD]
[TD="class: xl88"]£100.00[/TD]
[TD="class: xl88"]£110.00[/TD]
[TD="class: xl88"]£38.00[/TD]
[TD="class: xl88"]£49.50[/TD]
[TD="class: xl88"]£36.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£1,087.00[/TD]

[TD="class: xl68"]Sep-15[/TD]
[TD="class: xl88"]£220.00[/TD]
[TD="class: xl88"]£105.00[/TD]
[TD="class: xl88"]£115.00[/TD]
[TD="class: xl88"]£39.00[/TD]
[TD="class: xl88"]£50.50[/TD]
[TD="class: xl88"]£37.00[/TD]
[TD="class: xl88"]£220.00[/TD]
[TD="class: xl88"]£105.00[/TD]
[TD="class: xl88"]£115.00[/TD]
[TD="class: xl88"]£39.00[/TD]
[TD="class: xl88"]£50.50[/TD]
[TD="class: xl88"]£37.00[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl73"]£1,133.00[/TD]

[TD="class: xl68"]Oct-15[/TD]
[TD="class: xl88"]£230.00[/TD]
[TD="class: xl88"]£110.00[/TD]
[TD="class: xl88"]£120.00[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£51.50[/TD]
[TD="class: xl88"]£38.00[/TD]
[TD="class: xl88"]£230.00[/TD]
[TD="class: xl88"]£110.00[/TD]
[TD="class: xl88"]£120.00[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£51.50[/TD]
[TD="class: xl88"]£38.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,179.00[/TD]

[TD="class: xl68"]Nov-15[/TD]
[TD="class: xl88"]£240.00[/TD]
[TD="class: xl88"]£115.00[/TD]
[TD="class: xl88"]£125.00[/TD]
[TD="class: xl88"]£41.00[/TD]
[TD="class: xl88"]£52.50[/TD]
[TD="class: xl88"]£39.00[/TD]
[TD="class: xl88"]£240.00[/TD]
[TD="class: xl88"]£115.00[/TD]
[TD="class: xl88"]£125.00[/TD]
[TD="class: xl88"]£41.00[/TD]
[TD="class: xl88"]£52.50[/TD]
[TD="class: xl88"]£39.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,225.00[/TD]

[TD="class: xl68"]Dec-15[/TD]
[TD="class: xl88"]£250.00[/TD]
[TD="class: xl88"]£120.00[/TD]
[TD="class: xl88"]£130.00[/TD]
[TD="class: xl88"]£42.00[/TD]
[TD="class: xl88"]£53.50[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl88"]£250.00[/TD]
[TD="class: xl88"]£120.00[/TD]
[TD="class: xl88"]£130.00[/TD]
[TD="class: xl88"]£42.00[/TD]
[TD="class: xl88"]£53.50[/TD]
[TD="class: xl88"]£40.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,271.00[/TD]

[TD="class: xl68"]Jan-16[/TD]
[TD="class: xl88"]£260.00[/TD]
[TD="class: xl88"]£125.00[/TD]
[TD="class: xl88"]£135.00[/TD]
[TD="class: xl88"]£43.00[/TD]
[TD="class: xl88"]£54.50[/TD]
[TD="class: xl88"]£41.00[/TD]
[TD="class: xl88"]£260.00[/TD]
[TD="class: xl88"]£125.00[/TD]
[TD="class: xl88"]£135.00[/TD]
[TD="class: xl88"]£43.00[/TD]
[TD="class: xl88"]£54.50[/TD]
[TD="class: xl88"]£41.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,317.00[/TD]

[TD="class: xl68"]Feb-16[/TD]
[TD="class: xl88"]£270.00[/TD]
[TD="class: xl88"]£130.00[/TD]
[TD="class: xl88"]£140.00[/TD]
[TD="class: xl88"]£44.00[/TD]
[TD="class: xl88"]£55.50[/TD]
[TD="class: xl88"]£42.00[/TD]
[TD="class: xl88"]£270.00[/TD]
[TD="class: xl88"]£130.00[/TD]
[TD="class: xl88"]£140.00[/TD]
[TD="class: xl88"]£44.00[/TD]
[TD="class: xl88"]£55.50[/TD]
[TD="class: xl88"]£42.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,363.00[/TD]

[TD="class: xl68"]Mar-16[/TD]
[TD="class: xl88"]£280.00[/TD]
[TD="class: xl88"]£135.00[/TD]
[TD="class: xl88"]£145.00[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£56.50[/TD]
[TD="class: xl88"]£43.00[/TD]
[TD="class: xl88"]£280.00[/TD]
[TD="class: xl88"]£135.00[/TD]
[TD="class: xl88"]£145.00[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£56.50[/TD]
[TD="class: xl88"]£43.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,409.00[/TD]

[TD="class: xl68"]Apr-16[/TD]
[TD="class: xl88"]£290.00[/TD]
[TD="class: xl88"]£140.00[/TD]
[TD="class: xl88"]£150.00[/TD]
[TD="class: xl88"]£46.00[/TD]
[TD="class: xl88"]£57.50[/TD]
[TD="class: xl88"]£44.00[/TD]
[TD="class: xl88"]£290.00[/TD]
[TD="class: xl88"]£140.00[/TD]
[TD="class: xl88"]£150.00[/TD]
[TD="class: xl88"]£46.00[/TD]
[TD="class: xl88"]£57.50[/TD]
[TD="class: xl88"]£44.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,455.00[/TD]

[TD="class: xl68"]May-16[/TD]
[TD="class: xl88"]£300.00[/TD]
[TD="class: xl88"]£145.00[/TD]
[TD="class: xl88"]£155.00[/TD]
[TD="class: xl88"]£47.00[/TD]
[TD="class: xl88"]£58.50[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl88"]£300.00[/TD]
[TD="class: xl88"]£145.00[/TD]
[TD="class: xl88"]£155.00[/TD]
[TD="class: xl88"]£47.00[/TD]
[TD="class: xl88"]£58.50[/TD]
[TD="class: xl88"]£45.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,501.00[/TD]

[TD="class: xl68"]Jun-16[/TD]
[TD="class: xl88"]£310.00[/TD]
[TD="class: xl88"]£150.00[/TD]
[TD="class: xl88"]£160.00[/TD]
[TD="class: xl88"]£48.00[/TD]
[TD="class: xl88"]£59.50[/TD]
[TD="class: xl88"]£46.00[/TD]
[TD="class: xl88"]£310.00[/TD]
[TD="class: xl88"]£150.00[/TD]
[TD="class: xl88"]£160.00[/TD]
[TD="class: xl88"]£48.00[/TD]
[TD="class: xl88"]£59.50[/TD]
[TD="class: xl88"]£46.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,547.00[/TD]

[TD="class: xl68"]Jul-16[/TD]
[TD="class: xl88"]£320.00[/TD]
[TD="class: xl88"]£155.00[/TD]
[TD="class: xl88"]£165.00[/TD]
[TD="class: xl88"]£49.00[/TD]
[TD="class: xl88"]£60.50[/TD]
[TD="class: xl88"]£47.00[/TD]
[TD="class: xl88"]£320.00[/TD]
[TD="class: xl88"]£155.00[/TD]
[TD="class: xl88"]£165.00[/TD]
[TD="class: xl88"]£49.00[/TD]
[TD="class: xl88"]£60.50[/TD]
[TD="class: xl88"]£47.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,593.00[/TD]

[TD="class: xl68"]Aug-16[/TD]
[TD="class: xl88"]£330.00[/TD]
[TD="class: xl88"]£160.00[/TD]
[TD="class: xl88"]£170.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£61.50[/TD]
[TD="class: xl88"]£48.00[/TD]
[TD="class: xl88"]£330.00[/TD]
[TD="class: xl88"]£160.00[/TD]
[TD="class: xl88"]£170.00[/TD]
[TD="class: xl88"]£50.00[/TD]
[TD="class: xl88"]£61.50[/TD]
[TD="class: xl88"]£48.00[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£1,639.00[/TD]

[TD="class: xl68"]Sep-16[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£0.00[/TD]

[TD="class: xl68"]Oct-16[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£0.00[/TD]

[TD="class: xl68"]Nov-16[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£0.00[/TD]

[TD="class: xl68"]Dec-16[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£0.00[/TD]

[TD="class: xl68"]Jan-17[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£0.00[/TD]

[TD="class: xl68"]Feb-17[/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl73"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl73"]£0.00[/TD]

[TD="class: xl66"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl75"][/TD]

[TD="class: xl69"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl70"]Rolling Total[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl70"]Grand Total[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl70"]Best Month[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

</tbody>
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
Hi,

Take a look at this:


Excel 2016 (Windows) 64 bit
ABCDEFGHIJKLMNO
1NETT SPEND
2Supplier 1Supplier 2Supplier 3Supplier 4Supplier 5Supplier 6Supplier 7Supplier 8Supplier 9Supplier 10Supplier 11Supplier 12Monthly Totals
3CREDIT100100100100100100100100100100100100
4
5MONTH
6apr-14€ 50,00€ 20,00€ 30,00€ 22,00€ 33,50€ 20,00€ 50,00€ 20,00€ 30,00€ 22,00€ 33,50€ 20,00€ 351,00
7mei-14€ 60,00€ 25,00€ 35,00€ 23,00€ 34,50€ 21,00€ 60,00€ 25,00€ 35,00€ 23,00€ 34,50€ 21,00€ 397,00
8jun-14€ 70,00€ 30,00€ 40,00€ 24,00€ 35,50€ 22,00€ 70,00€ 30,00€ 40,00€ 24,00€ 35,50€ 22,00€ 443,00
9jul-14€ 80,00€ 35,00€ 45,00€ 25,00€ 36,50€ 23,00€ 80,00€ 35,00€ 45,00€ 25,00€ 36,50€ 23,00€ 489,00
10aug-14€ 90,00€ 40,00€ 50,00€ 26,00€ 37,50€ 24,00€ 90,00€ 40,00€ 50,00€ 26,00€ 37,50€ 24,00€ 535,00
11sep-14€ 100,00€ 45,00€ 55,00€ 27,00€ 38,50€ 25,00€ 100,00€ 45,00€ 55,00€ 27,00€ 38,50€ 25,00€ 581,00
12okt-14€ 110,00€ 50,00€ 60,00€ 28,00€ 39,50€ 26,00€ 110,00€ 50,00€ 60,00€ 28,00€ 39,50€ 26,00€ 627,00
13nov-14€ 120,00€ 55,00€ 65,00€ 29,00€ 40,50€ 27,00€ 120,00€ 55,00€ 65,00€ 29,00€ 40,50€ 27,00€ 673,00
33jul-16€ 320,00€ 155,00€ 165,00€ 49,00€ 60,50€ 47,00€ 320,00€ 155,00€ 165,00€ 49,00€ 60,50€ 47,00€ 1,593,00
34aug-16€ 330,00€ 160,00€ 170,00€ 50,00€ 61,50€ 48,00€ 330,00€ 160,00€ 170,00€ 50,00€ 61,50€ 48,00€ 1,639,00
35sep-16€ -
36okt-16€ -
37nov-16€ -
38dec-16€ -
39jan-17€ -
40feb-17€ -
41
42
431) Total for the past 12months from today's date (ie whenever we open the spreadsheet it updates based on the date)
44€ 3,300,00€ 1,590,00€ 1,710,00€ 534,00€ 672,00€ 510,00€ 3,300,00€ 1,590,00€ 1,710,00€ 534,00€ 672,00€ 510,00€ 16,632,00
45
462) Yearly Figure for the supplier (Jan to Dec)
47€ 2,360,00€ 1,140,00€ 1,220,00€ 372,00€ 464,00€ 356,00€ 2,360,00€ 1,140,00€ 1,220,00€ 372,00€ 464,00€ 356,00€ 11,824,00
48
495) Would like to be able to see the best month we've had with that supplier.
50€ 330,00€ 160,00€ 170,00€ 50,00€ 61,50€ 48,00€ 330,00€ 160,00€ 170,00€ 50,00€ 61,50€ 48,00€ 1,639,00
516) Grand total for all supplier from the start
52€ 5,510,00€ 2,610,00€ 2,900,00€ 1,044,00€ 1,377,50€ 986,00€ 5,510,00€ 2,610,00€ 2,900,00€ 1,044,00€ 1,377,50€ 986,00€ 28,855,00
Sheet1
Cell Formulas
RangeFormula
B44=SUM(OFFSET(INDIRECT(ADDRESS(MATCH(9.99999999999999E+307,B1:B40),COLUMN(B1))),0,0,-12,1))
B47=SUMPRODUCT((YEAR($A$6:$A$40)=YEAR(TODAY()))*B6:B40)
B50=LARGE(B6:B40,1)
B52=SUM(B6:B40)
 
Upvote 0
jorismoerings said:
Hi,

Take a look at this:

Excel 2016 (Windows) 64 bit
ABCDEFGHIJKLMNO
NETT SPEND
Supplier 1Supplier 2Supplier 3Supplier 4Supplier 5Supplier 6Supplier 7Supplier 8Supplier 9Supplier 10Supplier 11Supplier 12Monthly Totals
CREDIT
MONTH
1) Total for the past 12months from today's date (ie whenever we open the spreadsheet it updates based on the date)
2) Yearly Figure for the supplier (Jan to Dec)
5) Would like to be able to see the best month we've had with that supplier.
6) Grand total for all supplier from the start

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]apr-14[/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 20,00 [/TD]
[TD="align: right"] € 30,00 [/TD]
[TD="align: right"] € 22,00 [/TD]
[TD="align: right"] € 33,50 [/TD]
[TD="align: right"] € 20,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 20,00 [/TD]
[TD="align: right"] € 30,00 [/TD]
[TD="align: right"] € 22,00 [/TD]
[TD="align: right"] € 33,50 [/TD]
[TD="align: right"] € 20,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 351,00 [/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]mei-14[/TD]
[TD="align: right"] € 60,00 [/TD]
[TD="align: right"] € 25,00 [/TD]
[TD="align: right"] € 35,00 [/TD]
[TD="align: right"] € 23,00 [/TD]
[TD="align: right"] € 34,50 [/TD]
[TD="align: right"] € 21,00 [/TD]
[TD="align: right"] € 60,00 [/TD]
[TD="align: right"] € 25,00 [/TD]
[TD="align: right"] € 35,00 [/TD]
[TD="align: right"] € 23,00 [/TD]
[TD="align: right"] € 34,50 [/TD]
[TD="align: right"] € 21,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 397,00 [/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]jun-14[/TD]
[TD="align: right"] € 70,00 [/TD]
[TD="align: right"] € 30,00 [/TD]
[TD="align: right"] € 40,00 [/TD]
[TD="align: right"] € 24,00 [/TD]
[TD="align: right"] € 35,50 [/TD]
[TD="align: right"] € 22,00 [/TD]
[TD="align: right"] € 70,00 [/TD]
[TD="align: right"] € 30,00 [/TD]
[TD="align: right"] € 40,00 [/TD]
[TD="align: right"] € 24,00 [/TD]
[TD="align: right"] € 35,50 [/TD]
[TD="align: right"] € 22,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 443,00 [/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]jul-14[/TD]
[TD="align: right"] € 80,00 [/TD]
[TD="align: right"] € 35,00 [/TD]
[TD="align: right"] € 45,00 [/TD]
[TD="align: right"] € 25,00 [/TD]
[TD="align: right"] € 36,50 [/TD]
[TD="align: right"] € 23,00 [/TD]
[TD="align: right"] € 80,00 [/TD]
[TD="align: right"] € 35,00 [/TD]
[TD="align: right"] € 45,00 [/TD]
[TD="align: right"] € 25,00 [/TD]
[TD="align: right"] € 36,50 [/TD]
[TD="align: right"] € 23,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 489,00 [/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]aug-14[/TD]
[TD="align: right"] € 90,00 [/TD]
[TD="align: right"] € 40,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 26,00 [/TD]
[TD="align: right"] € 37,50 [/TD]
[TD="align: right"] € 24,00 [/TD]
[TD="align: right"] € 90,00 [/TD]
[TD="align: right"] € 40,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 26,00 [/TD]
[TD="align: right"] € 37,50 [/TD]
[TD="align: right"] € 24,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 535,00 [/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]sep-14[/TD]
[TD="align: right"] € 100,00 [/TD]
[TD="align: right"] € 45,00 [/TD]
[TD="align: right"] € 55,00 [/TD]
[TD="align: right"] € 27,00 [/TD]
[TD="align: right"] € 38,50 [/TD]
[TD="align: right"] € 25,00 [/TD]
[TD="align: right"] € 100,00 [/TD]
[TD="align: right"] € 45,00 [/TD]
[TD="align: right"] € 55,00 [/TD]
[TD="align: right"] € 27,00 [/TD]
[TD="align: right"] € 38,50 [/TD]
[TD="align: right"] € 25,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 581,00 [/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]okt-14[/TD]
[TD="align: right"] € 110,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 60,00 [/TD]
[TD="align: right"] € 28,00 [/TD]
[TD="align: right"] € 39,50 [/TD]
[TD="align: right"] € 26,00 [/TD]
[TD="align: right"] € 110,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 60,00 [/TD]
[TD="align: right"] € 28,00 [/TD]
[TD="align: right"] € 39,50 [/TD]
[TD="align: right"] € 26,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 627,00 [/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]nov-14[/TD]
[TD="align: right"] € 120,00 [/TD]
[TD="align: right"] € 55,00 [/TD]
[TD="align: right"] € 65,00 [/TD]
[TD="align: right"] € 29,00 [/TD]
[TD="align: right"] € 40,50 [/TD]
[TD="align: right"] € 27,00 [/TD]
[TD="align: right"] € 120,00 [/TD]
[TD="align: right"] € 55,00 [/TD]
[TD="align: right"] € 65,00 [/TD]
[TD="align: right"] € 29,00 [/TD]
[TD="align: right"] € 40,50 [/TD]
[TD="align: right"] € 27,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 673,00 [/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]jul-16[/TD]
[TD="align: right"] € 320,00 [/TD]
[TD="align: right"] € 155,00 [/TD]
[TD="align: right"] € 165,00 [/TD]
[TD="align: right"] € 49,00 [/TD]
[TD="align: right"] € 60,50 [/TD]
[TD="align: right"] € 47,00 [/TD]
[TD="align: right"] € 320,00 [/TD]
[TD="align: right"] € 155,00 [/TD]
[TD="align: right"] € 165,00 [/TD]
[TD="align: right"] € 49,00 [/TD]
[TD="align: right"] € 60,50 [/TD]
[TD="align: right"] € 47,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 1,593,00 [/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]aug-16[/TD]
[TD="align: right"] € 330,00 [/TD]
[TD="align: right"] € 160,00 [/TD]
[TD="align: right"] € 170,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 61,50 [/TD]
[TD="align: right"] € 48,00 [/TD]
[TD="align: right"] € 330,00 [/TD]
[TD="align: right"] € 160,00 [/TD]
[TD="align: right"] € 170,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 61,50 [/TD]
[TD="align: right"] € 48,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 1,639,00 [/TD]

[TD="align: center"]35[/TD]
[TD="align: right"]sep-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] € - [/TD]

[TD="align: center"]36[/TD]
[TD="align: right"]okt-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] € - [/TD]

[TD="align: center"]37[/TD]
[TD="align: right"]nov-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] € - [/TD]

[TD="align: center"]38[/TD]
[TD="align: right"]dec-16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] € - [/TD]

[TD="align: center"]39[/TD]
[TD="align: right"]jan-17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] € - [/TD]

[TD="align: center"]40[/TD]
[TD="align: right"]feb-17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] € - [/TD]

[TD="align: center"]41[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]44[/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 3,300,00 [/TD]
[TD="align: right"] € 1,590,00 [/TD]
[TD="align: right"] € 1,710,00 [/TD]
[TD="align: right"] € 534,00 [/TD]
[TD="align: right"] € 672,00 [/TD]
[TD="align: right"] € 510,00 [/TD]
[TD="align: right"] € 3,300,00 [/TD]
[TD="align: right"] € 1,590,00 [/TD]
[TD="align: right"] € 1,710,00 [/TD]
[TD="align: right"] € 534,00 [/TD]
[TD="align: right"] € 672,00 [/TD]
[TD="align: right"] € 510,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 16,632,00 [/TD]

[TD="align: center"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]47[/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 2,360,00 [/TD]
[TD="align: right"] € 1,140,00 [/TD]
[TD="align: right"] € 1,220,00 [/TD]
[TD="align: right"] € 372,00 [/TD]
[TD="align: right"] € 464,00 [/TD]
[TD="align: right"] € 356,00 [/TD]
[TD="align: right"] € 2,360,00 [/TD]
[TD="align: right"] € 1,140,00 [/TD]
[TD="align: right"] € 1,220,00 [/TD]
[TD="align: right"] € 372,00 [/TD]
[TD="align: right"] € 464,00 [/TD]
[TD="align: right"] € 356,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 11,824,00 [/TD]

[TD="align: center"]48[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]49[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]50[/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 330,00 [/TD]
[TD="align: right"] € 160,00 [/TD]
[TD="align: right"] € 170,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 61,50 [/TD]
[TD="align: right"] € 48,00 [/TD]
[TD="align: right"] € 330,00 [/TD]
[TD="align: right"] € 160,00 [/TD]
[TD="align: right"] € 170,00 [/TD]
[TD="align: right"] € 50,00 [/TD]
[TD="align: right"] € 61,50 [/TD]
[TD="align: right"] € 48,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 1,639,00 [/TD]

[TD="align: center"]51[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]52[/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 5,510,00 [/TD]
[TD="align: right"] € 2,610,00 [/TD]
[TD="align: right"] € 2,900,00 [/TD]
[TD="align: right"] € 1,044,00 [/TD]
[TD="align: right"] € 1,377,50 [/TD]
[TD="align: right"] € 986,00 [/TD]
[TD="align: right"] € 5,510,00 [/TD]
[TD="align: right"] € 2,610,00 [/TD]
[TD="align: right"] € 2,900,00 [/TD]
[TD="align: right"] € 1,044,00 [/TD]
[TD="align: right"] € 1,377,50 [/TD]
[TD="align: right"] € 986,00 [/TD]
[TD="align: right"][/TD]
[TD="align: right"] € 28,855,00 [/TD]

</tbody>
Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B44[/TH]
[TD="align: left"]=SUM(OFFSET(INDIRECT(ADDRESS(MATCH(9.99999999999999E+307,B1:B40),COLUMN(B1))),0,0,-12,1))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B47[/TH]
[TD="align: left"]=SUMPRODUCT((YEAR($A$6:$A$40)=YEAR(TODAY()))*B6:B40)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B50[/TH]
[TD="align: left"]=LARGE(B6:B40,1)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B52[/TH]
[TD="align: left"]=SUM(B6:B40)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Hi Thanks for replying
Will i have to alter this formula once i go past row 40? is there anyway i can change this to know automatically know what the last row is?
thanks
 
Upvote 0
[TABLE="width: 1661"]
<colgroup><col span="15"><col><col><col span="2"><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 6"]I would like the spreadsheet to be able to show us the following[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23/12/2015[/TD]
[TD="align: right"]22/12/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]22/12/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"]1) Total for the past 12months from today's date (ie whenever we open the spreadsheet it updates based on the date)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD="align: right"]23/12/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]2) Yearly Figure for the supplier (Jan to Dec)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 8"]4) Would like this to be a rolling so we can keep adding to the bottom of the sheet.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/04/2014[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]5) Would like to be able to see the best month we've had with that supplier.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/05/2014[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]6) Grand total for all supplier from the start[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23/12/2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/06/2014[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23/12/2015[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/07/2014[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 12"]Thanks in advance for any suggestions and support that you can provide and hope you all have a nice break and a good new year.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2014[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/09/2014[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/10/2014[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]NETT SPEND[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/11/2014[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Supplier 1[/TD]
[TD]Supplier 2[/TD]
[TD]Supplier 3[/TD]
[TD]Supplier 4[/TD]
[TD]Supplier 5[/TD]
[TD]Supplier 6[/TD]
[TD]Supplier 7[/TD]
[TD]Supplier 8[/TD]
[TD]Supplier 9[/TD]
[TD]Supplier 10[/TD]
[TD]Supplier 11[/TD]
[TD]Supplier 12[/TD]
[TD="colspan: 2"]Monthly Totals[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/12/2014[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CREDIT[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MONTH[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]automatic rolling last 12 months[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/02/2015[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Apr-14[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£20.00[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£22.00[/TD]
[TD="align: right"]£33.50[/TD]
[TD="align: right"]£20.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£20.00[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£22.00[/TD]
[TD="align: right"]£33.50[/TD]
[TD="align: right"]£20.00[/TD]
[TD][/TD]
[TD="align: right"]£351.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/03/2015[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]May-14[/TD]
[TD="align: right"]£60.00[/TD]
[TD="align: right"]£25.00[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£23.00[/TD]
[TD="align: right"]£34.50[/TD]
[TD="align: right"]£21.00[/TD]
[TD="align: right"]£60.00[/TD]
[TD="align: right"]£25.00[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£23.00[/TD]
[TD="align: right"]£34.50[/TD]
[TD="align: right"]£21.00[/TD]
[TD][/TD]
[TD="align: right"]£397.00[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/04/2015[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jun-14[/TD]
[TD="align: right"]£70.00[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£24.00[/TD]
[TD="align: right"]£35.50[/TD]
[TD="align: right"]£22.00[/TD]
[TD="align: right"]£70.00[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£24.00[/TD]
[TD="align: right"]£35.50[/TD]
[TD="align: right"]£22.00[/TD]
[TD][/TD]
[TD="align: right"]£443.00[/TD]
[TD][/TD]
[TD]Supplier 1[/TD]
[TD]Supplier 2[/TD]
[TD]Supplier 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/05/2015[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jul-14[/TD]
[TD="align: right"]£80.00[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£25.00[/TD]
[TD="align: right"]£36.50[/TD]
[TD="align: right"]£23.00[/TD]
[TD="align: right"]£80.00[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£25.00[/TD]
[TD="align: right"]£36.50[/TD]
[TD="align: right"]£23.00[/TD]
[TD][/TD]
[TD="align: right"]£489.00[/TD]
[TD][/TD]
[TD]3660[/TD]
[TD]1770[/TD]
[TD]1890[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/06/2015[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Aug-14[/TD]
[TD="align: right"]£90.00[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£26.00[/TD]
[TD="align: right"]£37.50[/TD]
[TD="align: right"]£24.00[/TD]
[TD="align: right"]£90.00[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£26.00[/TD]
[TD="align: right"]£37.50[/TD]
[TD="align: right"]£24.00[/TD]
[TD][/TD]
[TD="align: right"]£535.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/07/2015[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Sep-14[/TD]
[TD="align: right"]£100.00[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£55.00[/TD]
[TD="align: right"]£27.00[/TD]
[TD="align: right"]£38.50[/TD]
[TD="align: right"]£25.00[/TD]
[TD="align: right"]£100.00[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£55.00[/TD]
[TD="align: right"]£27.00[/TD]
[TD="align: right"]£38.50[/TD]
[TD="align: right"]£25.00[/TD]
[TD][/TD]
[TD="align: right"]£581.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2015[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Oct-14[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£60.00[/TD]
[TD="align: right"]£28.00[/TD]
[TD="align: right"]£39.50[/TD]
[TD="align: right"]£26.00[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£60.00[/TD]
[TD="align: right"]£28.00[/TD]
[TD="align: right"]£39.50[/TD]
[TD="align: right"]£26.00[/TD]
[TD][/TD]
[TD="align: right"]£627.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/09/2015[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Nov-14[/TD]
[TD="align: right"]£120.00[/TD]
[TD="align: right"]£55.00[/TD]
[TD="align: right"]£65.00[/TD]
[TD="align: right"]£29.00[/TD]
[TD="align: right"]£40.50[/TD]
[TD="align: right"]£27.00[/TD]
[TD="align: right"]£120.00[/TD]
[TD="align: right"]£55.00[/TD]
[TD="align: right"]£65.00[/TD]
[TD="align: right"]£29.00[/TD]
[TD="align: right"]£40.50[/TD]
[TD="align: right"]£27.00[/TD]
[TD][/TD]
[TD="align: right"]£673.00[/TD]
[TD][/TD]
[TD="colspan: 2"]formula giving 3660[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/10/2015[/TD]
[TD="align: right"]19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Dec-14[/TD]
[TD="align: right"]£130.00[/TD]
[TD="align: right"]£60.00[/TD]
[TD="align: right"]£70.00[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£41.50[/TD]
[TD="align: right"]£28.00[/TD]
[TD="align: right"]£130.00[/TD]
[TD="align: right"]£60.00[/TD]
[TD="align: right"]£70.00[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£41.50[/TD]
[TD="align: right"]£28.00[/TD]
[TD][/TD]
[TD="align: right"]£719.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/11/2015[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jan-15[/TD]
[TD="align: right"]£140.00[/TD]
[TD="align: right"]£65.00[/TD]
[TD="align: right"]£75.00[/TD]
[TD="align: right"]£31.00[/TD]
[TD="align: right"]£42.50[/TD]
[TD="align: right"]£29.00[/TD]
[TD="align: right"]£140.00[/TD]
[TD="align: right"]£65.00[/TD]
[TD="align: right"]£75.00[/TD]
[TD="align: right"]£31.00[/TD]
[TD="align: right"]£42.50[/TD]
[TD="align: right"]£29.00[/TD]
[TD][/TD]
[TD="align: right"]£765.00[/TD]
[TD][/TD]
[TD="colspan: 6"]=SUM(OFFSET($A$14,$Q$7,Q16):OFFSET($A$14,$R$7,Q16))[/TD]
[TD="align: right"]01/12/2015[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Feb-15[/TD]
[TD="align: right"]£150.00[/TD]
[TD="align: right"]£70.00[/TD]
[TD="align: right"]£80.00[/TD]
[TD="align: right"]£32.00[/TD]
[TD="align: right"]£43.50[/TD]
[TD="align: right"]£30.00[/TD]
[TD="align: right"]£150.00[/TD]
[TD="align: right"]£70.00[/TD]
[TD="align: right"]£80.00[/TD]
[TD="align: right"]£32.00[/TD]
[TD="align: right"]£43.50[/TD]
[TD="align: right"]£30.00[/TD]
[TD][/TD]
[TD="align: right"]£811.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2016[/TD]
[TD="align: right"]22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Mar-15[/TD]
[TD="align: right"]£160.00[/TD]
[TD="align: right"]£75.00[/TD]
[TD="align: right"]£85.00[/TD]
[TD="align: right"]£33.00[/TD]
[TD="align: right"]£44.50[/TD]
[TD="align: right"]£31.00[/TD]
[TD="align: right"]£160.00[/TD]
[TD="align: right"]£75.00[/TD]
[TD="align: right"]£85.00[/TD]
[TD="align: right"]£33.00[/TD]
[TD="align: right"]£44.50[/TD]
[TD="align: right"]£31.00[/TD]
[TD][/TD]
[TD="align: right"]£857.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/02/2016[/TD]
[TD="align: right"]23[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Apr-15[/TD]
[TD="align: right"]£170.00[/TD]
[TD="align: right"]£80.00[/TD]
[TD="align: right"]£90.00[/TD]
[TD="align: right"]£34.00[/TD]
[TD="align: right"]£45.50[/TD]
[TD="align: right"]£32.00[/TD]
[TD="align: right"]£170.00[/TD]
[TD="align: right"]£80.00[/TD]
[TD="align: right"]£90.00[/TD]
[TD="align: right"]£34.00[/TD]
[TD="align: right"]£45.50[/TD]
[TD="align: right"]£32.00[/TD]
[TD][/TD]
[TD="align: right"]£903.00[/TD]
[TD][/TD]
[TD="colspan: 5"]uses todays date to give start and end months[/TD]
[TD][/TD]
[TD="align: right"]01/03/2016[/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]May-15[/TD]
[TD="align: right"]£180.00[/TD]
[TD="align: right"]£85.00[/TD]
[TD="align: right"]£95.00[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£46.50[/TD]
[TD="align: right"]£33.00[/TD]
[TD="align: right"]£180.00[/TD]
[TD="align: right"]£85.00[/TD]
[TD="align: right"]£95.00[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£46.50[/TD]
[TD="align: right"]£33.00[/TD]
[TD][/TD]
[TD="align: right"]£949.00[/TD]
[TD][/TD]
[TD="colspan: 2"]in the top mini table[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/04/2016[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jun-15[/TD]
[TD="align: right"]£190.00[/TD]
[TD="align: right"]£90.00[/TD]
[TD="align: right"]£100.00[/TD]
[TD="align: right"]£36.00[/TD]
[TD="align: right"]£47.50[/TD]
[TD="align: right"]£34.00[/TD]
[TD="align: right"]£190.00[/TD]
[TD="align: right"]£90.00[/TD]
[TD="align: right"]£100.00[/TD]
[TD="align: right"]£36.00[/TD]
[TD="align: right"]£47.50[/TD]
[TD="align: right"]£34.00[/TD]
[TD][/TD]
[TD="align: right"]£995.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/05/2016[/TD]
[TD="align: right"]26[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jul-15[/TD]
[TD="align: right"]£200.00[/TD]
[TD="align: right"]£95.00[/TD]
[TD="align: right"]£105.00[/TD]
[TD="align: right"]£37.00[/TD]
[TD="align: right"]£48.50[/TD]
[TD="align: right"]£35.00[/TD]
[TD="align: right"]£200.00[/TD]
[TD="align: right"]£95.00[/TD]
[TD="align: right"]£105.00[/TD]
[TD="align: right"]£37.00[/TD]
[TD="align: right"]£48.50[/TD]
[TD="align: right"]£35.00[/TD]
[TD][/TD]
[TD="align: right"]£1,041.00[/TD]
[TD][/TD]
[TD="colspan: 2"]ie 21 and 32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/06/2016[/TD]
[TD="align: right"]27[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Aug-15[/TD]
[TD="align: right"]£210.00[/TD]
[TD="align: right"]£100.00[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£38.00[/TD]
[TD="align: right"]£49.50[/TD]
[TD="align: right"]£36.00[/TD]
[TD="align: right"]£210.00[/TD]
[TD="align: right"]£100.00[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£38.00[/TD]
[TD="align: right"]£49.50[/TD]
[TD="align: right"]£36.00[/TD]
[TD][/TD]
[TD="align: right"]£1,087.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/07/2016[/TD]
[TD="align: right"]28[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Sep-15[/TD]
[TD="align: right"]£220.00[/TD]
[TD="align: right"]£105.00[/TD]
[TD="align: right"]£115.00[/TD]
[TD="align: right"]£39.00[/TD]
[TD="align: right"]£50.50[/TD]
[TD="align: right"]£37.00[/TD]
[TD="align: right"]£220.00[/TD]
[TD="align: right"]£105.00[/TD]
[TD="align: right"]£115.00[/TD]
[TD="align: right"]£39.00[/TD]
[TD="align: right"]£50.50[/TD]
[TD="align: right"]£37.00[/TD]
[TD][/TD]
[TD="align: right"]£1,133.00[/TD]
[TD][/TD]
[TD="colspan: 2"]21 from lookup table[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/08/2016[/TD]
[TD="align: right"]29[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Oct-15[/TD]
[TD="align: right"]£230.00[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£120.00[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£51.50[/TD]
[TD="align: right"]£38.00[/TD]
[TD="align: right"]£230.00[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£120.00[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£51.50[/TD]
[TD="align: right"]£38.00[/TD]
[TD][/TD]
[TD="align: right"]£1,179.00[/TD]
[TD][/TD]
[TD="colspan: 2"]32 is just add 11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/09/2016[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Nov-15[/TD]
[TD="align: right"]£240.00[/TD]
[TD="align: right"]£115.00[/TD]
[TD="align: right"]£125.00[/TD]
[TD="align: right"]£41.00[/TD]
[TD="align: right"]£52.50[/TD]
[TD="align: right"]£39.00[/TD]
[TD="align: right"]£240.00[/TD]
[TD="align: right"]£115.00[/TD]
[TD="align: right"]£125.00[/TD]
[TD="align: right"]£41.00[/TD]
[TD="align: right"]£52.50[/TD]
[TD="align: right"]£39.00[/TD]
[TD][/TD]
[TD="align: right"]£1,225.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/10/2016[/TD]
[TD="align: right"]31[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Dec-15[/TD]
[TD="align: right"]£250.00[/TD]
[TD="align: right"]£120.00[/TD]
[TD="align: right"]£130.00[/TD]
[TD="align: right"]£42.00[/TD]
[TD="align: right"]£53.50[/TD]
[TD="align: right"]£40.00[/TD]
[TD="align: right"]£250.00[/TD]
[TD="align: right"]£120.00[/TD]
[TD="align: right"]£130.00[/TD]
[TD="align: right"]£42.00[/TD]
[TD="align: right"]£53.50[/TD]
[TD="align: right"]£40.00[/TD]
[TD][/TD]
[TD="align: right"]£1,271.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/11/2016[/TD]
[TD="align: right"]32[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jan-16[/TD]
[TD="align: right"]£260.00[/TD]
[TD="align: right"]£125.00[/TD]
[TD="align: right"]£135.00[/TD]
[TD="align: right"]£43.00[/TD]
[TD="align: right"]£54.50[/TD]
[TD="align: right"]£41.00[/TD]
[TD="align: right"]£260.00[/TD]
[TD="align: right"]£125.00[/TD]
[TD="align: right"]£135.00[/TD]
[TD="align: right"]£43.00[/TD]
[TD="align: right"]£54.50[/TD]
[TD="align: right"]£41.00[/TD]
[TD][/TD]
[TD="align: right"]£1,317.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/12/2016[/TD]
[TD="align: right"]33[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Feb-16[/TD]
[TD="align: right"]£270.00[/TD]
[TD="align: right"]£130.00[/TD]
[TD="align: right"]£140.00[/TD]
[TD="align: right"]£44.00[/TD]
[TD="align: right"]£55.50[/TD]
[TD="align: right"]£42.00[/TD]
[TD="align: right"]£270.00[/TD]
[TD="align: right"]£130.00[/TD]
[TD="align: right"]£140.00[/TD]
[TD="align: right"]£44.00[/TD]
[TD="align: right"]£55.50[/TD]
[TD="align: right"]£42.00[/TD]
[TD][/TD]
[TD="align: right"]£1,363.00[/TD]
[TD][/TD]
[TD="colspan: 4"]should be able to use same approach[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017[/TD]
[TD="align: right"]34[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Mar-16[/TD]
[TD="align: right"]£280.00[/TD]
[TD="align: right"]£135.00[/TD]
[TD="align: right"]£145.00[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£56.50[/TD]
[TD="align: right"]£43.00[/TD]
[TD="align: right"]£280.00[/TD]
[TD="align: right"]£135.00[/TD]
[TD="align: right"]£145.00[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£56.50[/TD]
[TD="align: right"]£43.00[/TD]
[TD][/TD]
[TD="align: right"]£1,409.00[/TD]
[TD][/TD]
[TD="colspan: 3"]combined with MAX function[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/02/2017[/TD]
[TD="align: right"]35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Apr-16[/TD]
[TD="align: right"]£290.00[/TD]
[TD="align: right"]£140.00[/TD]
[TD="align: right"]£150.00[/TD]
[TD="align: right"]£46.00[/TD]
[TD="align: right"]£57.50[/TD]
[TD="align: right"]£44.00[/TD]
[TD="align: right"]£290.00[/TD]
[TD="align: right"]£140.00[/TD]
[TD="align: right"]£150.00[/TD]
[TD="align: right"]£46.00[/TD]
[TD="align: right"]£57.50[/TD]
[TD="align: right"]£44.00[/TD]
[TD][/TD]
[TD="align: right"]£1,455.00[/TD]
[TD][/TD]
[TD="colspan: 2"]to give best month[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/03/2017[/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]May-16[/TD]
[TD="align: right"]£300.00[/TD]
[TD="align: right"]£145.00[/TD]
[TD="align: right"]£155.00[/TD]
[TD="align: right"]£47.00[/TD]
[TD="align: right"]£58.50[/TD]
[TD="align: right"]£45.00[/TD]
[TD="align: right"]£300.00[/TD]
[TD="align: right"]£145.00[/TD]
[TD="align: right"]£155.00[/TD]
[TD="align: right"]£47.00[/TD]
[TD="align: right"]£58.50[/TD]
[TD="align: right"]£45.00[/TD]
[TD][/TD]
[TD="align: right"]£1,501.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/04/2017[/TD]
[TD="align: right"]37[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jun-16[/TD]
[TD="align: right"]£310.00[/TD]
[TD="align: right"]£150.00[/TD]
[TD="align: right"]£160.00[/TD]
[TD="align: right"]£48.00[/TD]
[TD="align: right"]£59.50[/TD]
[TD="align: right"]£46.00[/TD]
[TD="align: right"]£310.00[/TD]
[TD="align: right"]£150.00[/TD]
[TD="align: right"]£160.00[/TD]
[TD="align: right"]£48.00[/TD]
[TD="align: right"]£59.50[/TD]
[TD="align: right"]£46.00[/TD]
[TD][/TD]
[TD="align: right"]£1,547.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/05/2017[/TD]
[TD="align: right"]38[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jul-16[/TD]
[TD="align: right"]£320.00[/TD]
[TD="align: right"]£155.00[/TD]
[TD="align: right"]£165.00[/TD]
[TD="align: right"]£49.00[/TD]
[TD="align: right"]£60.50[/TD]
[TD="align: right"]£47.00[/TD]
[TD="align: right"]£320.00[/TD]
[TD="align: right"]£155.00[/TD]
[TD="align: right"]£165.00[/TD]
[TD="align: right"]£49.00[/TD]
[TD="align: right"]£60.50[/TD]
[TD="align: right"]£47.00[/TD]
[TD][/TD]
[TD="align: right"]£1,593.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/06/2017[/TD]
[TD="align: right"]39[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Aug-16[/TD]
[TD="align: right"]£330.00[/TD]
[TD="align: right"]£160.00[/TD]
[TD="align: right"]£170.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£61.50[/TD]
[TD="align: right"]£48.00[/TD]
[TD="align: right"]£330.00[/TD]
[TD="align: right"]£160.00[/TD]
[TD="align: right"]£170.00[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£61.50[/TD]
[TD="align: right"]£48.00[/TD]
[TD][/TD]
[TD="align: right"]£1,639.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/07/2017[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Sep-16[/TD]
[TD="align: right"]£340.00[/TD]
[TD="align: right"]£165.00[/TD]
[TD="align: right"]£175.00[/TD]
[TD="align: right"]£51.00[/TD]
[TD="align: right"]£62.50[/TD]
[TD="align: right"]£49.00[/TD]
[TD="align: right"]£340.00[/TD]
[TD="align: right"]£165.00[/TD]
[TD="align: right"]£175.00[/TD]
[TD="align: right"]£51.00[/TD]
[TD="align: right"]£62.50[/TD]
[TD="align: right"]£49.00[/TD]
[TD][/TD]
[TD="align: right"]£1,685.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Oct-16[/TD]
[TD="align: right"]£350.00[/TD]
[TD="align: right"]£170.00[/TD]
[TD="align: right"]£180.00[/TD]
[TD="align: right"]£52.00[/TD]
[TD="align: right"]£63.50[/TD]
[TD="align: right"]£50.00[/TD]
[TD="align: right"]£350.00[/TD]
[TD="align: right"]£170.00[/TD]
[TD="align: right"]£180.00[/TD]
[TD="align: right"]£52.00[/TD]
[TD="align: right"]£63.50[/TD]
[TD="align: right"]£50.00[/TD]
[TD][/TD]
[TD="align: right"]£1,731.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Nov-16[/TD]
[TD="align: right"]£360.00[/TD]
[TD="align: right"]£175.00[/TD]
[TD="align: right"]£185.00[/TD]
[TD="align: right"]£53.00[/TD]
[TD="align: right"]£64.50[/TD]
[TD="align: right"]£51.00[/TD]
[TD="align: right"]£360.00[/TD]
[TD="align: right"]£175.00[/TD]
[TD="align: right"]£185.00[/TD]
[TD="align: right"]£53.00[/TD]
[TD="align: right"]£64.50[/TD]
[TD="align: right"]£51.00[/TD]
[TD][/TD]
[TD="align: right"]£1,777.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Dec-16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Jan-17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]Feb-17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Rolling Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Grand Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Best Month[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi jorismoerings,

You kindly answered my post previously and wondered if you could answer this question for me,

On Row 47 it shows year to date, what i would like to do is do a comparison to the same time period last year. So if the sheet is doing Jan 17 to April 17 it will compare it with it to Jan 16 to April 16, if i load the sheet up in September it will compare Jan 17 - Sept 17 with Jan 16 - Sept 16. Once i have this information i would like to show it as a percentage increase or decrease. Is it possible to do this as one formula?
thanks
James
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Add item in first digits with create space after it based on sheet name
Replies
8
Views
89
kvsrinivasamurthy
K
H
  • Solved
Getting the last price for each duplicates ID
Replies
2
Views
128
Hasson
H
A
  • Solved
Merge QTY & AMOUNT for each part of item for each range
Replies
2
Views
62
Amer Omar
A
T
  • Question Question
copy last column for each sheet and the ID for each adjacent cells
Replies
0
Views
138
tubrak
T
A
  • Solved
compare brands between two sheets and show minus and positive values based on date (today)
Replies
6
Views
235
abdo meghari
A

Forum statistics

Threads
1,223,262
Messages
6,171,080
Members
452,377
Latest member
bradfordsam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top