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
I'm having problems with my spread sheet. I highlight a row to sum and it
adds everything but the first line. I tally each months expenses into a
total and then use that total as the basis of next month's opening balance
but Open Office is not allowing that. If I highlight and auto sum lines
11