Sumproduct to compute weighted avg #VALUE

[cartica]

Hi,

I was wondering how i can get my sumproduct to work. I want to only include certain values (one's included), but don't want to delete the values of the ones I am not including for this formula.

Thanks

question.xlsx

[oeldere]

What is the criteria for "certain values"?

[cartica]

what i currently have in my formula are the numbers i want to do a weighted average for

[ben_hensel]

You need to include a test conditional on, say, column C to test whether you include it or not.

So fill C6:C26 with boolean TRUE/FALSE for "to include?" and it's as simple as this:

Please Login or Register  to view this content.

Or something like that.

But you've buried the data governing which rows to pick into the formula, so either you move that information out of the function or you need to just stack a bunch with dumb brute force, like:

Please Login or Register  to view this content.

[cartica]

That does not work

Please Login or Register  to view this content.

[ben_hensel]

Of course it doesn't

You've got some spelled "SUMPRODCUT" with the U and C switched.

[cartica]

you are correct. this now works, thank you