How can I do this cumulative?

Romano_odK

Active Member
Joined
Jun 4, 2020
Messages
380
Office Version
  1. 365
Platform
  1. Windows
Good morning,
In the added sheet I got some sales from a few years. I want to achieve that I can see cumulative month over month of the last year. So February 2023 should look at the same month last year. Also a year over year would be great. What I can I do to achieve this, sure I guess a pivot table is one of the options. What should be my best approach and how?

Thank you for your time,

Romano

Omzet debiteuren 100 1.13.xlsm
ABCDEFGHIJKLMNOPQRSTU
2DateCustomerQuantityAmountCustomer20222023JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
313/07/2021 16:55Piet Voorschoten20315,81Piet Voorschoten
413/07/2021 16:55Piet Voorschoten1120,7Schilder Nederland
517/06/2021 16:30Piet Voorschoten12370,84
619/11/2021 12:02Piet Voorschoten40348
725/02/2022 14:50Piet Voorschoten12439,52
810/03/2022 16:26Piet Voorschoten169,61
919/11/2021 12:02Piet Voorschoten2106,77
1025/02/2022 14:50Piet Voorschoten80284,59
1116/05/2022 15:54Piet Voorschoten20356,71
1216/05/2022 15:54Piet Voorschoten20325,49
1316/05/2022 15:54Piet Voorschoten20356,71
1416/05/2022 15:54Piet Voorschoten20325,49
1508/02/2022 10:23Piet Voorschoten10162,75
1625/02/2022 14:50Piet Voorschoten20356,71
1713/01/2022 08:34Piet Voorschoten1040,17
1801/03/2021 15:58Schilder Nederland2094,86
1929/06/2020 08:18Schilder Nederland25331,54
2029/06/2020 08:18Schilder Nederland560,98
2107/12/2020 08:09Schilder Nederland10132,62
2207/12/2020 08:09Schilder Nederland560,98
2311/12/2020 13:42Schilder Nederland30121,97
2415/12/2020 16:48Schilder Nederland2079,13
2530/03/2021 16:42Schilder Nederland30121,97
2601/04/2021 16:39Schilder Nederland2094,86
2701/04/2021 16:39Schilder Nederland2057,35
2805/02/2021 15:04Schilder Nederland15198,92
2905/02/2021 15:04Schilder Nederland560,98
3005/02/2021 15:04Schilder Nederland20144,96
3108/10/2020 16:55Schilder Nederland12269,79
3208/10/2020 16:55Schilder Nederland3080,37
3308/07/2020 07:59Schilder Nederland533,82
3415/02/2021 15:54Schilder Nederland2066,55
3501/03/2021 15:58Schilder Nederland2094,86
3629/06/2020 08:18Schilder Nederland25331,54
3729/06/2020 08:18Schilder Nederland560,98
3807/12/2020 08:09Schilder Nederland10132,62
3907/12/2020 08:09Schilder Nederland560,98
4011/12/2020 13:42Schilder Nederland30121,97
4115/12/2020 16:48Schilder Nederland2079,13
4230/03/2021 16:42Schilder Nederland30121,97
4301/04/2021 16:39Schilder Nederland2094,86
4401/04/2021 16:39Schilder Nederland2057,35
4505/02/2021 15:04Schilder Nederland15198,92
4605/02/2021 15:04Schilder Nederland560,98
4705/02/2021 15:04Schilder Nederland20144,96
4808/10/2020 16:55Schilder Nederland12269,79
4908/10/2020 16:55Schilder Nederland3080,37
5008/07/2020 07:59Schilder Nederland533,82
5115/02/2021 15:54Schilder Nederland2066,55
Sheet1
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I'm not certain what you mean. Can you work out the results manually for that sample data and enter them in the relevant cells and re-post the sample?
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

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