weighted average formula for month

[ganeshkumar]

Hi,

please find the attachment, i need weighted average for month, i need formula in "Z 6" cell based on the weekly count....

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[ganeshkumar]

Hi ,

Thanks for help, but i need output based on week output, i already i used sum-product in everyweek , here i mentioned the example ...

Week 23 Week 24 Week 25 Month
273 743 273 1289
87% 95% 87% 92%

[Richard Buttrey]

.. but the weeks are only sums of the 7 days. Provided the weekly totals columns are excluded then the whole range may be used. The weekly total columns are excluded by virtue of the MOD(COLUMN(),8) part of the sumproduct.

The answer I've given is I believe correct. If you believe otherwise please indicate what you think the result should be.

[ganeshkumar]

Thanks Richard