LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Is it possible to skip a row in a formula that calculates totals?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula only calculates when clicked kbenedict Excel Worksheet Functions 1 April 24th 07 07:04 PM
a formula which calculates empty cells jeff lebowski Excel Discussion (Misc queries) 1 July 15th 06 12:29 AM
formula that calculates upon saving only hw Excel Discussion (Misc queries) 2 May 26th 05 03:47 PM
How do I write an Excel formula that re-calculates every 24 hrs? heather Excel Discussion (Misc queries) 3 May 4th 05 10:58 AM
Is there a template that calculates inventory totals? rcyphert Excel Worksheet Functions 1 January 4th 05 03:35 AM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"