Conditional Weighted Average with Multiple Variables

[Chellobi]

Hey guys,

Spent about 5 hours or more trying to figure this out.. I don't see myself completing the formula without help.

I need the weighted average for [(P) Storeys] where the following criteria are met:

1: [(C) Approved] = "Pending"
2: [(O) Approved] = "Pending"
3: [(O) Approved] ="*Divisional*"

How do I do this?
My closes success, possibly:

=SUMPRODUCT((Master[(P) Storeys])*(Master[(C) Approved]={"Pending"})*(Master[OMB Approved]={"Pending","*Divisional*"}))/SUMPRODUCT(--((Master[(C) Approved]={"Pending"})*(Master[OMB Approved]={"Pending","*Divisional*"})))

.. but it returns as #DIV/0!

 

[Chellobi]

Whoops,
typo

My formula is

=SUMPRODUCT((Master[(P) Storeys])*(Master[(C) Approved]={"Pending"})*(Master[(O) Approved]={"Pending","*Divisional*"}))/SUMPRODUCT(--((Master[(C) Approved]={"Pending"})*(Master[(O) Approved]={"Pending","*Divisional*"})))