cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate average for results

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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