Ugent Help!!
 

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

Ugent Help!!
 

I believe this will work

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

Tell me if it doesn't


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

Ugent Help!!
 

"Senior" wrote in
message ...

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

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

Ugent Help!!
 

THANKYOU VERY MUCH MATE!!

it's worked, much much appreciated :)


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

Ugent Help!!
 

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Senior" wrote in message
...

THANKYOU VERY MUCH MATE!!

it's worked, much much appreciated :)


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