Formula returns 0

C

cwillberg

Hi,

I am using some basic of formulas, SUM and MAX, within a large file
have started to give 0 as an answer even when this is not the true
result. The same formulas were working previously but have now stopped.
I'm not sure if i have change some display setting, but I don't seem to
be apply to get them to return to how they where.

Any help would be greatly appreciated
Chris
 
J

Jerry W. Lewis

What does COUNT(range) return? If zero, then the data in your cells are
character strings that only look like numbers.

Jerry
 
Top