| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiply arrays
In
=SUMPRODUCT(SUMIF(D110:D114,{"0"},G110:G114*'ROI Questions'!B34:B38)) replace "0"} with "0" Add ) after G114 and ( before 'ROI in other words try =SUMPRODUCT(SUMIF(D110:D114,"0",G110:G114)*('ROI Questions'!B34:B38)) What do you actually want to calculate? "Gary" wrote: What's wrong with this formula? =SUMPRODUCT(SUMIF(D110:D114,{"0"},G110:G114*'ROI Questions'!B34:B38)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Avg Arrays | Excel Worksheet Functions | |||
| add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
| 3D Arrays | Excel Worksheet Functions | |||
| Arrays | Excel Worksheet Functions | |||
| Multiply non-contigious arrays | Excel Discussion (Misc queries) | |||
Threaded Mode
