Log In
Register
Home
New Member
March 14, 2021
Offline
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 help
The following users say thank you to Silver Bullet for this useful post:
Purfleet
Trusted Members
December 20, 2019
Offline
Can you please add an example work.book, pictures are of little use
New Member
March 14, 2021
Offline
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.
Trusted Members
December 20, 2019
Offline
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
1 Guest(s)
