software

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: www.excelforum.com/member.php...oamp;userid=32672
View this thread: www.excelforum.com/showthread...hreadid=524794
I believe this will work

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

Tell me if it doesn't--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: www.excelforum.com/member.php...oamp;userid=31214
View this thread: www.excelforum.com/showthread...hreadid=524794quot;Seniorquot; gt; wrote in
message ...
gt;
gt; Right i'm balls at Excel and i have been giving a task at work on Excel
gt; and im totally stumped!
gt;
gt; I have a spreadsheet - a formula in it is =SUM(C19 B20), =SUM(C20 B21),
gt; =SUM(C21 B22) and so on. So for example i insert a figure into the B21
gt; and the C coloum keeps a running total
gt;
gt; I need All the cells below C31 to show zero but keep the formula so
gt; data can be added at a later date, instead it shows 600 all the way
gt; down the table *600 was the last amount) Don't really know how to
gt; describe what i want but i hope someone can help!
gt;
gt;
gt; --
gt; Senior
gt; ------------------------------------------------------------------------
gt; Senior's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32672
gt; View this thread: 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

THANKYOU VERY MUCH MATE!!

it's worked, much much appreciated --
Senior
------------------------------------------------------------------------
Senior's Profile: www.excelforum.com/member.php...oamp;userid=32672
View this thread: www.excelforum.com/showthread...hreadid=524794It might be helpful to look at
www.mvps.org/dmcritchie/excel/insrtrow.htm
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Seniorquot; gt; wrote in message
...
gt;
gt; THANKYOU VERY MUCH MATE!!
gt;
gt; it's worked, much much appreciated
gt;
gt;
gt; --
gt; Senior
gt; ------------------------------------------------------------------------
gt; Senior's Profile: www.excelforum.com/member.php...oamp;userid=32672
gt; View this thread: www.excelforum.com/showthread...hreadid=524794
gt;