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
|