Sum column in excel

Help
, , ,
1

I want to sum column amount, tax in excel.
But number in file as text.

image

Please guide me about it.

2

Hi @fairymemay

U can the linq query to obtain the sum

First read the excel file and store in dt1

For getting sum of amount

dt1.AsEnumerable().Sum(Function (row) Cint(row(“amount”)).ToString

Similarly u can do this for other columns too

2 Likes
3

lets use CDbl instead to keep the fractions
dt1.AsEnumerable().Sum(Function (row) CDbl(row(“amount”).toString.Trim)).ToString

2 Likes
4

It errors.
image

5

check for empty values in the datatable as empty values cannot be converted with CDbl
ideally there should no empty values (maybe overhead of to many blank rows)
so it is suggested to get control on the not needed rows

A work around could be:
dt1.AsEnumerable().Sum(Function (row) CDbl(“0” & row(“amount”).toString.Trim)).ToString

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.