Sum the values in the column by column range

Hi, I was wondering if there is a way to sum a column without column name. Like I can provide the range E4:E8 then to sum the values in it.

Is it possible?

Thank you xoxo

@sangasangasanga yes it is possible.

You can try either of below:

dt.Compute(“Sum(“”)”, “”).ToString();

Convert.ToInt32(dt.Compute(“SUM(Column2)”, “Column1 =‘’”))

And also, can you confirm if you have installed this package.

image

1 Like

I just installed the package. Could you please elaborate on your solution?

You can go through the below link for the better understanding on this:

1 Like