I’m also very curious. I want it to automatically keep running totals as I add numbers. Like if I add a line item to profit for d job, I want it to automatically add that to sny other numbers I have in my profits line. Therefore giving me s running total of my yearly profits. I don’t want to have to do it one by one. I want it to keep a running total but I haven’t been able to find a way to do that
What if you want it to continuously add to any line item added to a profit line which would give me a running total of profits for the year. I’d hate to have to do it for every item. I thought there was a way to make it just automatically do it and keep a running total anytime I add another line item to my profit category. Or do you have to do it one by one. I thought there would have to be a way to automatically take my parts: labor line item and make it automatically subtract that from my bulled line item, which would give me my profits.
I receive an error THIS FORMULA CANT REFERENCE ITS ONW CELL OR DEPEND ON ANOTHER FURMULA THAT REFERENCE THIS CELL when I have created a formula on my spreadsheet. How to fix it.
Now how do I do this for multiple cells in the same column?
Did you get a reply for this? Trying to add 10% to the whole column
I’m also very curious. I want it to automatically keep running totals as I add numbers. Like if I add a line item to profit for d job, I want it to automatically add that to sny other numbers I have in my profits line. Therefore giving me s running total of my yearly profits. I don’t want to have to do it one by one. I want it to keep a running total but I haven’t been able to find a way to do that
just click the ones you want in the same column . works the same as he's done it for across .
He explains in this video: How to Sum a Column or Cells in Apple Numbers
@@tonyvaf He explains in this video: How to Sum a Column or Cells in Apple Numbers
Where's the formula bar? And why isn't it on the top of the page?
What if you want it to continuously add to any line item added to a profit line which would give me a running total of profits for the year. I’d hate to have to do it for every item. I thought there was a way to make it just automatically do it and keep a running total anytime I add another line item to my profit category. Or do you have to do it one by one. I thought there would have to be a way to automatically take my parts: labor line item and make it automatically subtract that from my bulled line item, which would give me my profits.
How to lock the cells used in the formula ?
I receive an error THIS FORMULA CANT REFERENCE ITS ONW CELL OR DEPEND ON ANOTHER FURMULA THAT REFERENCE THIS CELL when I have created a formula on my spreadsheet. How to fix it.