sumproduct alternative
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? |
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? |
All times are GMT +1. The time now is 02:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com