Sum and count of Excel rows

[Anil_G (Anil Gorthi)]

@Olivera_Kalinic

Awesome you have blank values in your datatable ok

change this line

Let s = grp.sum(function(x) If(IsNumeric(x("column").ToString),CDBL(x("column").ToString),0)).ToString

make sure you replace the column with the appropriate column name

cheers