So, I have a column A with positive and negative numbers, and I’m trying to find a formula that’s creates a running total of those figures in column B. So in each new row of column A, it would create a sum in column B, of the previous cell + the latest figure from column A, up to 100 cells.

I could do that semi manually and make a unique formula for each cell 1-100 in column B, I’m just wondering if there’s a simpler way?

I have also a single cell that has the total sum from 1-100 of column A. I’m wondering if this cell can be integrated into the formula somehow?

Thanks for any help! Much appreciated!