Adding Sum of Specific Data In Excel

[Rishik_Chowdary]

Hi,

Hope you all doing well… I have an excel file in that one of the NAME - “Rishi” was added two times so we have to calculate the sum of Prices for rishi (total - 50)

Bot has download the another excel after 1hour in that Excel it has some random equal names and we have calculate the sum…!!

Thanks,
Rishi

[ppr (Peter Preuss)]

we can group the data on the name and suming up the resulting group individually.

For implementation options have a look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Palaniyappan (Forum Leader)]

Hi

Have a View on this thread with a expression to group and sum a column

Linq query for groupby and sum

I have a datatable as below. I want to group by using Col3 and take sum of Col2. Input Datatable: Col1 – Col2 – Col3 – Col4 A – 11 – AA – XYZ B – 12 – RT – XYZ C – 13 – HL – XYZ D – 27 – AA – XYZ E – 17 – AA – XYZ F – 15 – RT – XYZ G – 24 – HL – XYZ OutPut required: Col1 – Col2 AA – 55 RT – 27 HL – 37 Please help me with the LINQ query. @ppr @arivu96 @ClaytonM

Cheers @Rishik_Chowdary