Comparing two excels and adding up the value of column

i have two excel sheets have to compare two columns range
after comparing i need to sum up the value of the 3 rd column can anyone give idea on this?

you were almost done
once after this if we want to sum up all the value in 3rd column in a assign activity
–yourdatatablename.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“yourcolumnname”).ToString.Trim) ).ToString

Cheers @priyankavivek

i have 2 columns with different column names in excel so in condition what should i give?

Do you want to sum both the columns or only one column
Cheers @priyankavivek

image please c the screenshot sir the output i need is quantity to be added if condition satisfy

Fine no worrites
are they aligned like this same sheet or
each table is from different sheet
Cheers @priyankavivek

1 Like

each from different excel file
1.invoice excel
2.grn file

then that would work buddy

were we facing any issue out with this
Cheers @priyankavivek

1 Like

its shows enumerable is not a memeber of

no worries
Kindly have a view on this

Cheers @priyankavivek

sure i look into this.thankyou

1 Like

did that work buddy
Cheers @priyankavivek

i was looking into…sir

1 Like