sum formula with filters

[maddockd]

Hi all--

I'm looking to implement a subtotal formula that updates depending on what filter I select.

I've attached a sample file of where I am trying to use it.

I want to have all of "FY18" add up depending on my filter, FY17, etc.

Thank you.

[TMS]

Can't see the formulae on an iPad but you're looking for =SUBTOTAL (109, range)

[63falcondude]

As TMS mentioned, you can include SUBTOTAL to your existing formula like this: =SUBTOTAL(109,H24,H29,H34,...)

or you can shorten the formula like this:

H8 =SUMPRODUCT(SUBTOTAL(9,OFFSET($H$24,ROW($H$24:$H$1063)-ROW(H24),0)),--($G$24:$G$1063=$G8))