A
Ang
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.
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.