Lets use the following scenario

Subdivision Name Price Total Units
Estates 168k 98
Villas not listed 16

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

Would the correct calculation here be

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

2. (168*98)+(0*16)/114
-the 114 denominator here is 98 + 16 total units. In other words INCLUDING a subdivision wit no price