Trouble getting a conditional Sumproduct formula to work

I'm trying to use a conditional sumproduct formula to automatically find the weighted average for different markets' avg. household income and unemployment rate. I've tried the following formula:

=SUMPRODUCT((--A:A=F2),B:B,C:C)/SUMIF(A:A,F2,B:B)

I know the SUMIF part works, but the SUMPRODUCT portion does not. I keep getting a "#VALUE!" error. What am I doing wrong with it? Thanks for your help!

I think you are trying to do this in G2:

=SUMPRODUCT(--(A:A=F2),B:B,C:C)/SUMIF(A:A,F2,B:B)

You had a bracket in the wrong place.

However, it is not a good idea to use full column references with SUMPRODUCT, as every cell in the range will be used in the calculation. Notice how sluggish it is when you copy the formula down.

Hope this helps.

Pete

Awesome, thanks for doing this. I also realized that I had a few N/A values which threw everything off. Now it works perfectly!

Glad to hear that.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete