View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Why does SUM not compute, even if the cells display numeric values

<Could this be because both cells where populated with a function that
returned a string?

Definitely. Use =VALUE(YourPresentFormula) instead

--
Kind regards,

Niek Otten

"George Furnell" wrote in message
...
Hi,
My formula =SUM(Q13:Q14) returns 0, despite the fact that both cells
contains numeric values. Could this be because both cells where populated
with a function that returned a string?

Hope you can help.

Kind regards

George Furnell