computations at odd locations
Utkarsh -
Assuming your data is in columns A-C with headers in row 1 and data starting
in row 2, you can get what you want by adding two columns.
Do not put anything in the normal header row D1.
In D2, enter
=IF(A1="Total",B2,B2+D1)
In E2, enter
=IF(A2="Total",B2,E3)
In C2, enter
=IF(A2="Total",1,B2/E2)
Drag these down the columns. column C will have the correct percents.
This all depends on the word Total being in column A at the end of each block.
--
Daryl S
"Utkarsh" wrote:
Hi
I have data available as follows:
Segment Value Percentage
A 2
B 7
C 5
Total
X 3
Y 2
Total
Q 4
W 6
E 3
R 8
Total
Unforrtunately, as you can see, the rows are unequal. I need to put
totals in the cell adjacent to where "Total" occurs. Also, based on
the totals percentage break-ups for each group needs to be computed.
Can someone suggest a way out?
.
|