View Single Post
  #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.