Urgent need help with SUM in column

[Silverbullet21]

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 beneath the 4 amounts), this same goes to company D with 3 amounts to be added. So basically a macro that will go through the whole column to check if a company has more than one amount and add them, otherwise if only one amount just if ignore. Please help

 

[My Aswer Is This]

Please provide more specific details.
Like search column A for all values below and put sum below last cell with data.
Is that what you want?
And do this on what columns?
Is it column A to Column M?
Or what?
And what is the sheet name?

 

[Michael M]

Why not simply create a PivotTable ??

 

[My Aswer Is This]

Why not simply create a PivotTable ??

I was thinking a standard Excel Table may work depending on exactly what is wanted.

 

[maabadi]

Welcome to MrExcel Message Board.
1. First If your Data is in Table, Convert to Range (Select one Cell in Table, Design Tab, Convert to Range)
2. Go to Data tab, Subtotal, Then Add Subtotal to Amounts (at Selection Pane with Mark Amount Column = 3rd Option) for Each Company (First Option).

 

[maabadi]

Or Try this Macro:

Sub Macro1()
Range("A2").Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(4), _
    Replace:=True, PageBreaks:=False, SummaryBelowData:=True
End Sub

1. Cell A2 or One Cell within Your Range
2. Group By: Column Number at your Range (If ComPany Name is First Column then Equal 1
3. TotalList: Number withinArray is ColumnNumber For Amounts at your range ( if Amounts is Column 4 at your Range then Equal Array(4))

 

[My Aswer Is This]

I use a Table and do the following:
1. Click any cell in Table Then Click Design Mode
2. Select Total Row. This will add a Total Row at bottom of your table
3. Now on total Row click icon and choose Sum in your case.
4. Now you will see results of the sum for that column
5. Copy that cell and paste where ever you want.
6. Now go back to Design mode unselect Total Row
7. Bingo you have the sum of that column even as you add more values to that column