Is there any shortcut for calculating the total value (SUM) for 1000s of records for each column?

I’m trying to use the looping conditions but since there are too many records it takes alot of time and most the time the robot fails. I have like 2000 rows and 6 such columns and I need to calculate the total value(SUM) of the 2000 rows for each of the columns. Is there any better way of doing it?

# Excel : Calculating total for each value of the records for each column

I would suggest using SQL when dealing with large amount of records in excel files.

Quick intro: Execute SQL queries against Excel

In this case, you could use the SUM() function:

https://www.w3schools.com/sql/sql_count_avg_sum.asp

2 Likes