sumproduct alternative

[Chris]

I am using a business objects application(Xcelsius) that uses excel
formulas to create graphical interfaces, but this application does not
support all excel formulas.

I am trying to recreate this formula:
=(SUBTOTAL(1,(Calculations!P21000))+SUBTOTAL(1,(Calculations!
U2:U1000)))/2

to use formulas that are supported by the application like
sumif
countif
sumproduct
etc.

any ideas?

 

[Bob Phillips]

=(AVERAGE(P210)+AVERAGE(U2:U10))/2