Lets use the following scenario

Subdivision NamePrice Total Units

Estates 168k 98

Villas not listed 16

Lets say I only wanted to know the sumproduct of those subdivisions with aprice range listed.

Would the correct calculation here be

1. (168*98)/98 = 168k

or

2. (168*98)+(0*16)/114

-the 114 denominator here is 98 + 16 total units. In other words INCLUDING a subdivision wit no price