Forum Discussion
Bank Reconciliations
I'm wanting to create a spreadsheet to complete bank reconciliations. My question is this, if I want to add another Row above the Total line how do I get the Total Formula to include the value entere...
Is your OFFSET formula correct. I get an error message to say there is something wrong and do I want them to fix it. I have said yes but it gives me a number that makes no sense at all. So I haven't been to make any progress yet.
I was typing in =SUM(G6:OFFSET(G10,-1.0)) (Applying this to the wrong cell)
But I was applying it to Cell B10. The G's should be B's. I'll give it another go.
You have -1.0 at the end. It should be -1,0
Thus a comma, not a decimal point. Then it should work.