| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct() - Next best alternative | Excel Discussion (Misc queries) | |||
| ALTERNATIVE TO SUMPRODUCT NEEDED | Excel Worksheet Functions | |||
| If alternative | Excel Worksheet Functions | |||
| Alternative to SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? | Excel Worksheet Functions | |||
Linear Mode
