Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using Excel 2003. I have 65 rows, and columns K-Q and S are manually
entered. Column R is the sum of K-Q. This is the formula that I have in column T except for the first row: =IF(R12*S12=0," ",((R12*S12)+T11)) I used this formula because the users do not wish for the running total to show in any but the last used row. Now they'd like to skip a row or two at intervals of their choice. My question is: How can I get my formula to continue to total if my users skip a row or two, without having to manually change my formula at each interval? Columns R and T are locked and protected. This is going to be their template. Thanks x10 to anyone who tries even if this is not possible. I just love this site!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula only calculates when clicked | Excel Worksheet Functions | |||
a formula which calculates empty cells | Excel Discussion (Misc queries) | |||
formula that calculates upon saving only | Excel Discussion (Misc queries) | |||
How do I write an Excel formula that re-calculates every 24 hrs? | Excel Discussion (Misc queries) | |||
Is there a template that calculates inventory totals? | Excel Worksheet Functions |