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
 
G

Guest

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

Jerry
 

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

Top