Consolidate data from individual months by summing 2, 3 or more months together

Kaleo

New Member
Joined
Sep 4, 2012
Messages
8
Hello,

I need to consolidate monthly targets data for salespersons by summing 2, 3 or more months together.

Details: I have a table with salespersons and their monthly targets, January through December. Sometimes I need to sum data from specific months, for example January+February+March or July+August etc in a new sheet, using a form.
I am too stupid to do this and I will really appreciate any help.

Thank you!

Dummy.xlsm
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1RegionSales personJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTOTAL 2024
2Car ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar CCar ACar BCar C
3COMPANY TOTAL10310010210499103107101103104104100104101102105100103105103103102107102103102101104100101103103101106100103125012201224
4Region 1John101211910111212131114119111010101191211101211101211101211101211101211120141133
5Region 1Mary121091210912109121091210912109121091210912109121091210912109144120108
6Region 1Sam878878878878878878878878878878878878968496
7Region 1Willie141211141211141211141211141211141211141211141211141211141211141211141211168144132
8REGION 1 TOTAL444139433939464141454339434038443939434139444139444139444139444139444139528489469
9Region 2Kevin998109897891081098119812981098119810989108119812110896
10Region 2Sandra109111191112910101091091210101110111110121110101110910109910911123116127
11Region 2Michael810128111281212910129101281112810138141281112910128101391012100129146
12REGION 2 TOTAL272831292931292830283029292832293031303032283531293031292830272930302831344353369
13Region 3Dan111112111112111112111112111112111112111112111112111112111112111112111112132132144
14Region 3Olivia910991099109910991099109910991099109910991099109108120108
15Region 3Ava121011121012121111111011121211121012121111101011101010111011121211121012138126134
16REGION 3 TOTAL323132323133323232313132323332323133323232303132303131313132323332323133378378386
17
18
19I need a macro that can sum monthly data by my choice (using a form, like in the picture)
20and put the results in a new sheet (like sheet "Result")
21Eg:January+February
22orJanuary+February+March
23orApril+May+June (Q2)
24etc
Data
Cell Formulas
RangeFormula
C3:AO3C3=C8+C12+C16
AM4:AO7,AM9:AO11,AM13:AO15AM4=C4+F4+I4+L4+O4+R4+U4+X4+AA4+AD4+AG4+AJ4
C8:AO8AM8=SUM(AM4:AM7)
C16:AO16,C12:AO12AM12=SUM(AM9:AM11)



Dummy.xlsm
ABCDEFGHIJK
1RegionSales personJanuary+February+March
2Car ACar BCar C
3COMPANY TOTAL314300308
4Region 1John313435
5Region 1Mary363027
6Region 1Sam242124
7Region 1Willie423633
8REGION 1 TOTAL133121119
9Region 2Kevin282524
10Region 2Sandra332732
11Region 2Michael243336
12REGION 2 TOTAL858592
13Region 2Dan333336
14Region 2Olivia273027
15Region 2Ava363134
16REGION 3 TOTAL969497
Result
Cell Formulas
RangeFormula
C3:E3C3=C8+C12+C16
C8:E8C8=SUM(C4:C7)
C12:E12,C16:E16C12=SUM(C9:C11)
 

Attachments

  • image_start.png
    image_start.png
    228.8 KB · Views: 12
  • image_months.png
    image_months.png
    69.1 KB · Views: 13
  • image_final.png
    image_final.png
    155.9 KB · Views: 12

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,884
Messages
6,175,177
Members
452,615
Latest member
bogeys2birdies

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