| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continue formula but without showing last total
I have a formula that totals a balance of columns C to F and I wish to copy
this formula down to line 1000. I am currently upto line 25 and lines 26 to 1000 shows the last balance, ie 1200 all the way down to line 1000. The formula I am using is =H24-SUM(C25:F25)+G25 What can I add to this formula to show lines 26 to 1000 as blank or 0, but will change when figures are entered in columns C-F. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Formula Showing Instead of Value :( | Excel Discussion (Misc queries) | |||
| formula in cell not showing result | Excel Worksheet Functions | |||
| XL formula - total of row = total of column | Excel Worksheet Functions | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
| a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
Threaded Mode
