Help in matrix total

Hi all Can you help me. I would like some columns to show the average, while others the sum. In the first column, I want the 'total' to appear as 7 ( ie average of 6 and 8 ), Whereas column No of Co...