sum funiction in datatable

Question

i have this table records in data table

datatable name is dt.

this datatable constrain these records

company name            money1              money2

cm1                               100                  50

cm2                               70                    30

cm1                               40                    60

 

i want same company must be in same line and amounts must be total amoun.

for example:

company name                    money1                 money2

cm1                                   140                            110         (2 line in one line with total money amount)

cm2                                   70                               30