AVERAGE function does not work

[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?

 

[Chip Pearson]

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)

 

[Bernard V Liengme]

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

 

[Jerry W. Lewis]

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