Correct Use of Average when using sumproduct?

**cmf0106** · 11-21-2009, 03:06 PM

In the attached file I designed a template which can only accommodate a list of 10 subdivisions (neighborhoods).

With that being said every template will have a subdivision list which I will use to populate the slots 1-10, the problem is there are often more than 10 subdivision for any given area. When this is the case I have to use the 10th slot as an other category.

For the other slot I decided to take a lump average for all subdivisions that fell into that category. I then use sumproduct for the various columns based on the variable e.g. lot size and the total amount (excavation + streets in + ... etc) in that subdivision. My question is this the correct use of the average?

**Richard Buttrey** · 11-21-2009, 03:54 PM

Hi,

Why are you trying to average the subdivision's subdivisions?

The first four columns deal with the upper and lower range values. Hence IMO you should be using the =MIN() and =MAX() functions for the Lot sizes and Price range.

HTH

**cmf0106** · 11-21-2009, 04:09 PM

Richard,

Im only averaging the variables of lot size and price for the subdivisions that fall into the other category (Hill Crest & The Woods in this case.)