Remember there is also the '$' to fix the range to either a row or a
cell. In the event you move your range, it will stick to the initial
cell.
Example:
$A11 -> will stick to column A
A$11 -> will stick to row 11
$A$11 -> will stick to both column A and row 11.
On 7/8/14, Martin Groenescheij wr
Select cell A111 and if it shows a *`* in the formula bar before the
value it is defined as text.
Just delete the ` and it should give you the correct results.
On 9-7-2014 2:12, Andrea Madott wrote:
I'm having problems with my spread sheet. I highlight a row to sum and it
adds everything bu