sumproduct alternative
=(AVERAGE(P2:P10)+AVERAGE(U2:U10))/2
--
__________________________________
HTH
Bob
"Chris" wrote in message
...
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?
|