Formula returns 0

  • Thread starter Thread starter cwillberg
  • Start date Start date
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
 
What does COUNT(range) return? If zero, then the data in your cells are
character strings that only look like numbers.

Jerry
 
You must log in or register to reply here.

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

Similar Threads

Multiple Logic in One Formula 0
Excel formula, sum the value cell and if empty cell left blank 0
Excel VBA 1
EXCEL - IF(IFERROR(VLOOKUP question 0
IF formula, Partial word, SUM function as result 1
Smaller than 0 to return a 0 result 1
Supress DIV/0 2
Formula/calculation returning a 0 instead of actual sum 4

Back
Top