How to use minus formula in sumproduct

[enterdelete123]

Hello All,

I want to minus negative score from total score. Example:

Let's take one positive survey will give 100% score and one negative survey gives 0% score. If we get 10 surveys out of which 9 are positive and 1 is negative, so the score will be 90%.

A11=100%, A12=0%
B11=9, B12=1

The formula is =sumproduct(A11:A12*B11:B12)/sum(B11:B12)

Now I want to remove that one negative survey from the total score of 90% using sumproduct formula. Please help!!

Attached is the file for better understanding.

Thanks.

[tim201110]

=sumproduct((A11:A12>0)*A11:A12*B11:B12)/sum(B11:B12)

[enterdelete123]

Not working..getting 90.91%. Should get 100%

[tim201110]

sorry
=sumproduct((A11:A12>0)*A11:A12*B11:B12)/sumproduct(--(A11:A12>0);B11:B12)

[enterdelete123]

It is giving formula you are using contains error, so i have corrected as

=sumproduct((A11:A12>0)*A11:A12*B11:B12)/sumproduct(--(A11:A12>0)*B11:B12)

But it is still giving me 90%.

See, we got 10 surveys out of which 9 are positive and 1 is negative.

positive = 100%, negative = 0%.

So if i remove 0%(negative survey), the answer should be 100%..please help

[enterdelete123]

Please check the attached file for clear understanding.

Let me know if you need any further details.

Thanks.

[benishiryo]

i couldn't really picture your formula inside the file because the cell references are different. so when you use:
=sumproduct(A11:A12*B11:B12)/sum(B11:B12)

i am guessing this actually refers to L11:M12? not sure why you need a SUMPRODUCT too. will this suffice?
=L11*M11/(M11-MIN(1,M12))

or referencing it directly to the data:
=COUNTIF(C11:C25,1)/(COUNT(C11:C25)-MIN(COUNTIF(C11:C25,0),1))

[enterdelete123]

You get me started..Thanks for your help!!

However, I found out the formula.

=L11*M11/(M11-M12)

[FDibbins]

Please do not post duplicate threads, I have closed your other thread