| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Try...
=SUMPRODUCT(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),0,1)),--(R ange=Criterion),RangeToSum) Hope this helps! In article , Bonobo wrote: I would need to sum a range of cells that match a certain condition (SUMIF), but I would need it to work as well being limited by the autofilter... anyone to help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal on SumIf | Excel Worksheet Functions | |||
| Can SUMIF function include AND function | Excel Worksheet Functions | |||
| Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
| Combining SUMIF and SUBTOTAL functions | Excel Worksheet Functions | |||
| Can you combined the SUMIF and SUBTOTAL functions in a formula? | Excel Worksheet Functions | |||
Threaded Mode
