Formula in Excel 2013

%3CLINGO-SUB%20id%3D%22lingo-sub-1785882%22%20slang%3D%22en-US%22%3EFormula%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1785882%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20way%20to%20use%20the%20function%20%22subtotal%22%20in%20the%20following%20formula%3A%20%3DSUMIF(%24T%246%3A%24T%24383%2C%22%3D19.1747.07%22%2C%24G%246%3A%24G%24383)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1785882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1785976%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1785976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834232%22%20target%3D%22_blank%22%3E%40jdilks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUMPRODUCT((%24T%246%3A%24T%24383%3D%2219.1747.07%22)*SUBTOTAL(109%2COFFSET(%24G%246%3A%24G%24383%2CROW(%24G%246%3A%24G%24383)-MIN(ROW(%24G%246%3A%24G%24383))%2C0%2C1%2C1)))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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

@Hans Vogelaar That worked perfectly.

Thank you!!!