Sum everything upto the current row number

So, I need to keep adding together all the numbers from cell row 0 upto and including the row number of the cell with the result. The column with the results is to the right of the column with numbers to add. So, if the numbers are positive, to the right of each should be an ever increasing number as a result. In the column with the numbers to add is a function which as a result gives either numbers or blank cells. It sounds simple but it is frustrating me. Why can't I use the function SUMIF with a ROW function inside the condition field? It always gives me 0 as the result. I use excel 2003.

I probably do't understand the SUMIF function but why isn't =SUMIF(A:A;"1>0") equivalent to =SUM(A:A). This too gives the result of 0. Why don't I get an error instead.

I think you simply need something like:

=Sum($A$1:A$1)

copied down

This will "freeze" the start of the range to A1 and as you copy down, the bottom of the range increases by 1... so you are doing a rolling sum.

Originally Posted by lampas89

=Sum($A$1:A$1) didn't work so I tried =Sum($A$1:A1) and that was it.

Freezing the first cell when copying was exactly what I wanted, just didn't know how to do it.

Thanks.

Yes, my mistake, I froze row instead of column... I meant to do this:

=Sum($A$1:$A1) and copy down.

If you've got a solution, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save