Trying to get the sum of currency values in an excel column. Guide me!

Help
1

trying to get the sum of currency values in a excel column but unable to do so.

Can anyone help??

Currency is ZAR column layout image is given below. Need to do the sum of the whole column!

image
image156×721 3.92 KB

Thanx in advance.

2

Hi @AryanSingh

Check this

dtFileter.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“Zar”).ToString.Split(" ".TocharArray)(1).Trim) )

3

wait let me share the excel file with u!

@AshwinS2

Please guide me with this!

4

Hey
Please check this excel sheet.
I want to sum column “T” name BaseOutstanding. There are sum null value cells also. Please check the excel sheet!
TIBS_Daily Transaction Data_02 August.xlsx (18.1 KB)

@AshwinS2

5

@AshwinS2

Please check the excel. And help me with the sum of the column

Thank You