| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Arrayformulas with either/or nested to sumproduct if either conditions are true
Hi Jonathan,
Am Thu, 27 Nov 2014 19:08:57 -0800 (PST) schrieb Jonathan Pence: =iferror(arrayformula(sumproduct((O$18:O35*($B$18: $B$35=$AE15))*($M$18:$M35*($B$18:$B$35=$AE15)))/sum(($M$18:$M$35*($B$18:$B$35=$AE$15)))),"") AE15=executed AE14=consider try: =IFERROR(SUMPRODUCT((($B$18:$B$35=AE14)+($B$18:$B$ 35=AE15))*$M$18:$M$35*$O$18:$O$35)/SUMPRODUCT((($B$18:$B$35=AE14)+($B$18:$B$35=AE15)) *$M$18:$M$35),"") could I use the same formula to satisfy the following: if A18:A35=Floating to Maturity +(or) Floating to the call AND executed +(or) consider, Sumproduct(N18:N35,M18:M35)/sum(M18:M35) add the argument in your formula similiar the other arguments Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if true, if not nested if funcion | Excel Worksheet Functions | |||
| IF statement with nested SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| Sumproduct with nested sum | Excel Worksheet Functions | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
Threaded Mode
