Forum

Urgent need help wi...
 
Notifications
Clear all

Urgent need help with SUM in a column

4 Posts
2 Users
0 Reactions
78 Views
(@silverbullet21)
Posts: 2
New Member
Topic starter
 

hi guys, i am a beginner here having problem in writing a dynamic macro that sums up the amount for a particular company that has more than one amount (i.e company C has 4 amounts to be summed up and i need to display the sum amount in D12), this same goes to company D. Please help20210314_122006.jpg

 
Posted : 15/03/2021 12:35 am
(@purfleet)
Posts: 412
Reputable Member
 

Can you please add an example work.book, pictures are of little use

 
Posted : 15/03/2021 12:51 am
(@silverbullet21)
Posts: 2
New Member
Topic starter
 

hi Purfleet, please find the attached picture as a sample. In this case, I would like the summed amount to be shown in cell D12 and D17.

 
Posted : 15/03/2021 8:40 am
(@purfleet)
Posts: 412
Reputable Member
 

By far the easist way to total these is to use the Outline Subtotal in the data tab

Select the 2 columns, then click Data>Subtotal in the ribbon, then follow the wizard (the default is probably correct) all companies are now totalled. If you dont like the look of the outline, you can then select ungroup >  Clear outline and you will just have the totales

 
Posted : 15/03/2021 4:03 pm
Share: