Forum Discussion
Bank Reconciliations
Yes, that works fine!
I believe you can use the suggested OFFSET option. By the way, do you have any particular reason to use formulas as =SUM(B10) or =SUM(B49+B50-B51). No need for the SUM function here.
Hi again Riny, I'm self taught and just do what seems to work and give me the outcome I am looking for.
=SUM(B10) & =SUM(B49+B50-B51). As I understand it, if the cell has no formula the cell is blank and the user has to put in their own value? Therefore it assumes the user knows where to get the correct value to place in that cell for the rest of the process to work automatically.
This spreadsheet is designed for people who know nothing about them (spreadsheets) and only want to track their cashflow and manage their financial life with some degree of detail.
If they input their line items each month then the rest of the work is done for them. They only have to learn what the numbers are telling them about their cashflows.
Is it possible to communicate with you directly or is it necessary to go through this Help function in Microsoft.
I'll try the OFFSET option you suggest, again. I did try it but wasn't getting the result I expected. Maybe I missed something and will have a closer look.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.
