Last 6 Months Production Summation

[RECLIP]

Hello Excel Forums,

I have a large vertical table built like the table below. The table has many IDs with many dates. I would like sum the last 6 months of each ID. Does any one have any ideas? Thank you!

ID	DATE	OIL PRODUCTION
DUMMYCASE1	01/31/2022	100
DUMMYCASE1	2/28/2022	32
DUMMYCASE1	03/31/2022	1323
DUMMYCASE1	4/28/2022	2312
DUMMYCASE72	01/31/2022	231
DUMMYCASE72	2/28/2022	65
DUMMYCASE72	03/31/2022	854
DUMMYCASE72	4/28/2022	325

 

[James006]

Hi,
Have you tried to insert a Pivot Table ?

 

[RECLIP]

Hi,
Have you tried to insert a Pivot Table ?

Not all IDs start in the same period or end at the same time. How would I use a pivot table?