| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
