Is there a way to easily get a weighted average of numbers that are not in a
contiguous set of rows or columns? I've tried combining lookup formulas with
arrays, sumif's, and sumproduct's but not succeeded. Used the long way by
summing the products with commas separating columns and clicking each cell,
but there must be an easier way. Thank you,