Weighted Average Formula Help

[annagcr]

I'm trying to write a formula to calculate the average investment size weighted by the total dollars we've invested and need to be able to separate out investments we've made through fund 1 and fund 2.

I thought it would look something like this:

=SUMPRODUCT(--(Cell Range ="Fund 1"),(Cell Range Containing Weight where weight = investment/total dollars invested),(Cell Range of Investments Made))/SUMPRODUCT(--('Cell Range="Fund 1"),(Cell Range of Investments Made))

but that produces a result that doesn't make any sense. Anyone have an idea as to what I'm doing incorrectly?

 

[C Moore]

Does total dollars invested need to be separated out by funds as well? I'm missing where weight comes in, seems like a straight average of investments made.