P Peo Sjoblom Jan 21, 2004 #2 If you are using a filter you can use =SUMPRODUCT(($B$2:$B$20>0)*(SUBTOTAL(3,OFFSET($B$2,ROW($B$2:$B$20)-MIN(ROW($ B$2:$B$20)),,)))) Where B2:B20 is the range If they are the result of hidden rows/columns you would need VBA or Excel 2003
If you are using a filter you can use =SUMPRODUCT(($B$2:$B$20>0)*(SUBTOTAL(3,OFFSET($B$2,ROW($B$2:$B$20)-MIN(ROW($ B$2:$B$20)),,)))) Where B2:B20 is the range If they are the result of hidden rows/columns you would need VBA or Excel 2003
