Forum Discussion

Copper Contributor

Oct 15, 2020

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)

MVP

Oct 15, 2020

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

Copper Contributor

Oct 16, 2020

HansVogelaar That worked perfectly.

Thank you!!!