formula for Weighted average?

[uttam.mothe]

Hi All,

Need formula for below scenario.

Please calculate the weightage average
before proceeding the calculation, Is weightage distributed correctly?

Category Marks Weightage
Test1 70 50%
Test2 90 10%
Test3 80 20%
Test4 60 30%


Regards,

Mothe

[oeldere]

in cell d1=b1*c1 and drag down.

in cell e1=SUM(D1:D5)/counta(B1:B4)

[uttam.mothe]

Hi Oeldere,

Please could explain the formula how it works,

Is weightage is distributed correctly??


Regards,

mothe

[samba_ravi]

Please attach sample file with desired / expected result

[uttam.mothe]

Hi,

I have attached the file.

[oeldere]

With the offered formula.

[samba_ravi]

Try
=SUMPRODUCT(B6:B9,C6:C9)/100%

[uttam.mothe]

when we sum the c colum it shows 110% means its not distributed correctly.

[oeldere]

Since you get 2 answers, it is always good to add to who you are replaying.

It is also good to add the expected result (manualy) in the file or in the text.