Why can't I use the sum function on the table I exported to Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I exported a table that I created in Access 2000 to Excel 2000 and tried
highlighting a column and pushing the "sum" button but instead of giving me
the sum of the numbers in the column on the empty cell at the bottom, it just
gives a formula at the top of the highlighted column and no answer. I don't
care if I use Excel or not; what I want to do is get averages of a bunch of
different sets of numbers in my table. I am a novice at Access and Excel. I
can do a query for the different sets I want in Access, or I can select and
cut and paste them in Excel. I am stuck at how to perform the function I want
(average) on them.
Thanks!
 
You should post Excel questions to Excel news group.
If the formula at the top of the highlighted column is correct then press
the ENTER key and the cell will display the sum. If formula is wrong then
edit it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Excel 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access to Excel 5
Exporting to Excel 4
SUM status bar 2
Rounding difference in Access 2003 text exports 2
acess sum 7
Turning a 3 column flat file into a "3D" Table 2

Back
Top