AVERAGE function does not work

  • Thread starter Thread starter Tom Arnold
  • Start date Start date
T

Tom Arnold

I have excel 97, and the average function does not work?
I tried reinstalling it, but still not working. I am on a
LAN and I suspect it has something to do with my profile.
Any suggestions?
 
Tom,

Specifically what do you mean when you say it "doesn't work"? I doubt it has
anything to do with your LAN or profile.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Hi Tom
Are you a long-time Lotus 1-2-3 user who recall average was AVG(A1:A100)
rather than =AVERAGE(A1:A100)?
Bernard
 
If you are using the correct syntax for AVERAGE() and getting zero as an
answer, then your data are probably text strings that only look like
numbers, and =COUNT(range) will return zero as well. The usual approach
to converting text to numeric numbers is to copy a cell containing zero,
select your data range, and Edit|Paste Special|Add

Jerry
 
Back
Top