I need to count number of columns in group

• i hate registration-456225

  SSC Enthusiast

  Points: 112

  More actions

  October 16, 2010 at 10:38 pm

  #225102

  hello,

  I need to count number of columns in group -

  I have a matrix with SUM in the date area.

  I have a group column (lats say 'city') and under it my columns (lats say 'street name');

  Under each 'street name' I have cell with SUM function.

  The problem is:

  When The main group (city) is not expand I get the sum of all cities and what I want to get is an average.

  So what I thought of was to divide that number in the number of streets under each city group.

  How can I get that number?

  Thanks.