#1 KPI with "SUMPRODUCT" Formula

[Anonymous]

Dear all,

I would like to create a #1 KPI to show Monthly Average Number as in the blue box in the print screen as well as a Yearly Average Number in the Red Box.

Actual calculation formula are as attached in the excel.

Thank you very much in advance for your assistance!

Cheers and Happy New Year!

訊息由此人編輯：Woon Han Yap

[MK9885]

You are missing the attachment with your question.

[Anonymous]

Thank you SKhan for your reply.

I had reattached again. Happy New Year!