AVERAGE function does not work

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

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
 
J

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
 
Top