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
Can you please add an example work.book, pictures are of little use
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.
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