Hi George,
Glad I could help, thanks for the feedback.
For the Value function to work on all the cells in the range Q13:Q14
the formula has to be entered as an array formula. Ctrl + Shift + Enter
achieves this. If you look in the Formula Bar after following that
process you will see that the formula is inside braces
ie {=SUM(VALUE(Q13:Q14))}. This makes it possible for you to determine
which cells have array formulas.
Ken Johnson