Oct 15 2020 01:34 PM
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)
Oct 15 2020 01:54 PM
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)))