How to calculate average for results

[Former Member]

Guys,

A1 B1 C1=B1/A1

A2 B2 C2=B2/A2

A3 B3 C3=B3/A3

A B C = B/A ( not average of ( C1C2C3 ) / 3 )

I have 2 column and I divide one by other..

I need total of 2 columns at the bottom and even that total

should be division of second column by first column..

how is it possible?

Regards

Rajesh

[Former Member]

Hi Rajesh,

Create one more characteristics structure for the characteristics you want to use.

Then go to the cell editor and create formula for the corresponding rown and columns to display the total values for the A1 and A2. B1 and B2.

hope you get this information...

Thanks

Ram