| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine Sumif and Subtotal
Try to combine a sumif in a subtotal row.
But got #VALUE! instead. Can someone advise what's wrong with this formular? =SUMPRODUCT((ISNUMBER(MATCH($E$5:$E$10,$E$8,0))),( SUBTOTAL(9,F$5:F$10))) or can I use a simpler one =sumif($E$5:$E$10,$E$8,(subtotal(9,F5:F10))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal vs calculate vs sumif ??? | Excel Worksheet Functions | |||
| Subtotal and sumif help | Excel Discussion (Misc queries) | |||
| subtotal and sumif | Excel Worksheet Functions | |||
| Sumif & subtotal | Excel Discussion (Misc queries) | |||
| Subtotal on SumIf | Excel Worksheet Functions | |||
Threaded Mode
