LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ang Ang is offline
external usenet poster
 
Posts: 36
Default how can I start and stop a sum formula?

Not sure if this is possible but I have 3 columns of focus where the rows
always change (data dump)

Column 1) is product line 2) each product lines $'s 3) is my calc

columns 1 states all product lines and then says "Results" for the sum of
column 2 with the items above it. So each product line will have its own
value and results will sum up everything above it. This goes on for many
product lines. I would like to know where I calc a % off of column 2 if
there is a way for me to include a formula on the results row that says if
this row says "result" sum everything above it and stop at whatever row says
"result". I need it to only sum between all results.
 
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 to find Stop Time from Start Time and Total Minutes Jonathan Bickett Excel Worksheet Functions 5 March 7th 07 05:22 PM
Formula for agenda to create start/stop with projected time of ev Dot Setting up and Configuration of Excel 0 March 9th 06 02:39 PM
How to chart start and stop times tresscott Charts and Charting in Excel 1 April 10th 05 11:04 PM
RTD Links, how to start and stop them [email protected] Excel Worksheet Functions 2 March 28th 05 12:44 PM
How can I get elapsed time between AM start/PM stop khacmac Excel Worksheet Functions 1 February 1st 05 11:17 PM


All times are GMT +1. The time now is 08:10 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"