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.

how can I start and stop a sum formula?
 

Is this what you want:

Prod1.....10.........
...............10.........
Results............20
Prod2.....10........
...............15........
...............10........
Results...........25

If so, try this entered in C1 and copied down as needed:

=IF(A1<"results","",SUM(B$1:B1)-SUM(C$1:INDEX(C:C,ROWS(C$1:C1)-1)))


--
Biff
Microsoft Excel MVP


"Ang" wrote in message
...
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.