Formula in Excel 2013

Copper Contributor

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

@jdilks 

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)))

@Hans Vogelaar That worked perfectly.

Thank you!!!