veremchuka
Thinks s/he gets paid by the post
I know next to nothing about spreadsheets. I looked at a few in work but never really had any experience using them and I never even attempted to make one.
I have a hobby for which I am tracking my costs and the volume of "things" I'm buying and using. I thought maybe a spreadsheet would be a good way to do this so last night I made a spreadsheet. I use Open Office (OO) and it has a spreadsheet (SS) option. So I took an Excel SS I had one from someone and saved it as an OO SS. I saw how to calculate totals from it and lo and behold I was able to change headings, delete columns and rows, add a column and many rows, wow I'm starting to think I may actually have a workable document.
Here's the problem. I have 3 or 4 sections, each has a total and at the end a grand total. If I add any new rows, like when I buy more stuff which is ongoing, it requires me to adjust the formula for the total in that section and the grand total.
Is it possible to have a formula that automatically adjusts for the new rows I add? If not this is too cumbersome to adjust each time I buy stuff and I am probably better just keeping track on paper or in an OO document where I will have to manually add the new purchases to the total and grand total.
I'd appreciate any help!
I have a hobby for which I am tracking my costs and the volume of "things" I'm buying and using. I thought maybe a spreadsheet would be a good way to do this so last night I made a spreadsheet. I use Open Office (OO) and it has a spreadsheet (SS) option. So I took an Excel SS I had one from someone and saved it as an OO SS. I saw how to calculate totals from it and lo and behold I was able to change headings, delete columns and rows, add a column and many rows, wow I'm starting to think I may actually have a workable document.
Here's the problem. I have 3 or 4 sections, each has a total and at the end a grand total. If I add any new rows, like when I buy more stuff which is ongoing, it requires me to adjust the formula for the total in that section and the grand total.
Is it possible to have a formula that automatically adjusts for the new rows I add? If not this is too cumbersome to adjust each time I buy stuff and I am probably better just keeping track on paper or in an OO document where I will have to manually add the new purchases to the total and grand total.
I'd appreciate any help!