Ending a running total (down a column) at a specific row.

[D_Blackwell]

I have a starting balance in C2 and want to carry a running balance of credits and debits in column C down column D.

This:
=SUM($C$2:C2)

does the trick, but I need to stop the calculation at C22 and I can't figure it out.

What am I missing?

 

[Warship]

What am I missing?
Just don't put anything in D22?

 

[D_Blackwell]

Column C continues its way down, but I only want the running total calculation for a specified number of rows, then I want it to stop.

 

[T. Valko]

Column C continues its way down, but I only want the running total calculation for a specified number of rows, then I want it to stop.

You could do something like this...

=IF(ROWS(C$2:C2)>N,"",SUM(C$2:C2))

Replace N with the number of rows you want the formula to calculate. N can also be a cell reference that holds the number.

A1 = some number

=IF(ROWS(C$2:C2)>A$1,"",SUM(C$2:C2))

 

[D_Blackwell]

That's just what I needed. There are 'sections' in column D that are being handled separately, but I was able to take your sample and make it workable. I have to ignore the warning for 'Inconsistent Calculation Column Formula' but everything is working correctly and I don't think that will be a problem.

Thanks.

 

[T. Valko]

That's just what I needed. There are 'sections' in column D that are being handled separately, but I was able to take your sample and make it workable. I have to ignore the warning for 'Inconsistent Calculation Column Formula' but everything is working correctly and I don't think that will be a problem.

Thanks.

You're welcome. Thanks for the feedback!