Sum data Excel without duplicate rows

Help Activities
, , ,
1

Dear all I am facing with an issue plz help me to solve this,
I have an excel with duplicate data. In column A I have Reference Number and in column O I have Amount.

I need to get the sum of Amount with respect to the duplicate Reference Number.

Example
Reference Number. Amount
ABC. 67
ABC. 67
Vgf. 1
Vgf. 1
So from the above example my sum of Amount must be 67+1=68.

How to get this. Please help me :pray:

2

Hi @hanviprebday ,
Could you share your simple file
I will code detail for you
It’s too easy
we filter data then calculate sum
I have created sample file similar with your mean
image
this’s my in/output
please check it
my source
SumExcel.zip (9.1 KB)

regards,

3

HI,

How about the following expression?

image
image898×455 18.2 KB

dt.AsEnumerable.GroupBy(Function(r) r(0).ToString).Sum(Function(g) g.Select(Function(r) CInt(r(1))).First())

Sample
Sample20231124-13.zip (2.7 KB)

Regards,