View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Ivan

it could be that your numbers are formatted as text - copy a blank cell from
another worksheet
select your numbers and the formula and choose edit / paste special - add
then select the formula cell press F2 and then enter

alternatively, check that calculation is not set to manual - tools / options
/ calculation - ensure that automatic is selected

Cheers
JulieD

"Ivan" wrote in message
...
I have a simple formula that adds amounts. It was working all the time but
now suddenly it's not adding on, i.e. the formula is still in the field
but
the result is not coming......

Can somebody help?