Skip to Content
0
Former Member
Sep 06, 2007 at 02:28 PM

to Display average in results in rows & totals in results in columns

70 Views

Hi all

we have a unique requirement ,for a list of KF, Bottom Lines:

Overall result.

Text: Total

Calculation in cells will be sum of respective cells instead of average.

Last right column:

Text: Average

Calculation in cells will be average of left side column.

If possible: Have column average in other color than Total lines

when i try to select the ´´display results as ´' as average, it will show average on both results columns, & similiar for totals.

I have searched a lot on the Excel Styles & all, but still couldnt find any solution ,

Please help me out.

Regards,

ramesh