Sum of all Repeated values in Excel

excel

#1

Hi,

I Have one data in Excel.
I want to get sum of all repeated value and paste in another sheet.
Example: sheet1 value:
A 10
A 10
A 10
B 20
C 30
C 30
result In another sheet Should be
A 30 (Sum of all repeated value)
B 20
C 50 (Sum of all repeated Value)


#2

Hi @Amarjeet566,
It may helps you.

Regards
Balamurugan


#3

Main.xaml (16.9 KB)
Refer this File,It may helps you.