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!P2:P1000))+SUBTOTAL(1,( Calculations!
U2:U1000)))/2

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

any ideas?