Convert Formula to Number Value

Formula values normally can't be summed up to give a total sum for a range of numbers. To be able to display the total sum of a range written in formula you have to convert each formula cell to number format. To do this you have to use "=VALUE()".
Theory:
=Value(Formula)
Example
=Value(Mid(Cell,Start number,Number of characters))
Or
=Value(Mid(A2,1,1))

Read More..