Highlighted
New Contributor

# 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
Highlighted

# Re: Formula in Excel 2013

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

# Re: Formula in Excel 2013

@Hans Vogelaar That worked perfectly.

Thank you!!!