Excel - Sum

Need to sum 30000(Rows) Data using Excel. Currently i am using the query[(Variable).AsEnumerable.Sum(Function(x)Double.Parse(x(“Amount”).ToString))]. It has taken 15 Mins. Kindly suggest is there any other way to sum the data within a short time.

Hello @prasanna_Y

If youa re trying to find the sum of a single columns you can use a Write cell activity and in teh value use the formula. You can refer below.

1 Like

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