How to dynamically calculate totals from data being exported

[Guest]

I have a function in Access that exports data into an Excel spreadsheet. I
want the spreadsheet to calculate the totals of each column and show the
results at the end of the column. The thing is each export may not have the
same amount of rows, so how can I get Excel to dynamically calculate the data
based the amount of rows exported.

Thanks,

Akilah

 

[Pete_UK]

Once you have imported the data into Excel, insert a new row 1 at the
very top of the sheet and use this for your totals - in A1 enter the
formula:

=SUM(A2:A65522)

to add up everything in column A - you could actually use 65536, but I
find 6 double-5 double-2 easier to remember and it covers almost the
complete range.

The formula can be copied across to the relevant columns.

Hope this helps.

Pete