Hi,

I'm using an array formula to calc a weighted average in a list but only for members of the list that satisfy a particular condition. However, I am getting a #value! error. I believe this is because some members of the list have an "na" or "No Data" value. Is there a formula that I could use that would do what I need it to do but would exclude members of list with "na" or "No Data" values. Below is the current formula I am using.

={SUMPRODUCT(($HO$15:$HO$830=1)*(H15:H830)*(FO15:FO830))/SUMPRODUCT((FO15:FO830)*($HO$15:$HO$830=1))}

Thanks so much!

A