Ugent Help!!

[Senior]

Right i'm balls at Excel and i have been giving a task at work on Exce
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 B2
and the C coloum keeps a running total

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

 

[coa01gsb]

I believe this will work

=IF($B:$B=0,0,SUM(C21+B22) )

Tell me if it doesn't

 

[Beege]

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!

Hi senior

First, adding two cells doesn't require =SUM(), all you need is =C19+B20
Second, use the =IF() to blank cells that aren't filled in yet

Check the help file for IF

Beege

 

[Senior]

THANKYOU VERY MUCH MATE!!

it's worked, much much appreciated :

 

[David McRitchie]

It might be helpful to look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
http://www.mvps.org/dmcritchie/excel/offset.htm
to see why I would use OFFSET in the formulas so you can
insert and delete rows.