Right i'm balls at Excel and i have been giving a task at work on Excel
and im totally stumped!

I have a spreadsheet - a formula in it is =SUM(C19+B20), =SUM(C20+B21),
=SUM(C21+B22) and so on. So for example i insert a figure into the B21
and the C coloum keeps a running total

I need All the cells below C31 to show zero but keep the formula so
data can be added at a later date, instead it shows 600 all the way
down the table *600 was the last amount) Don't really know how to
describe what i want but i hope someone can help!


--
Senior
------------------------------------------------------------------------
Senior's Profile: http://www.excelforum.com/member.php...o&userid=32672
View this thread: http://www.excelforum.com/showthread...hreadid=524794