Forum Discussion
Formula in Excel 2013
Is there a way to use the function "subtotal" in the following formula: =SUMIF($T$6:$T$383,"=19.1747.07",$G$6:$G$383)
2 Replies
Try
=SUMPRODUCT(($T$6:$T$383="19.1747.07")*SUBTOTAL(109,OFFSET($G$6:$G$383,ROW($G$6:$G$383)-MIN(ROW($G$6:$G$383)),0,1,1)))
