How to Sum column values in Excel

[prasath_S]

Hi @nithya

Please refer this post,

Find sum of values by grouping in a Data Table

Hello All, I have a Data Table as below: [Capture] What I would like to find out is the sum of all Invoice Values corresponding to a Client Name. So the output should be like below: <ClientName 1>:Total Invoice Value <ClientName 2>:Total Invoice Value … … and so on. How shall I get this done. Kindly help. Regards.

Thanks