Filtering - Capturing a filtered subtotal on a separate sheet

[therichterscale]

Using filters, I have filtered out Tuition - Elementary in column E and Discount annually on F on sheet 1 with a subtotal. I want to capture that same subtotal on a separate summary page, is this possible with a formula or should I just manually calculate each category of grade level and the adjustment reason separately? Unfortuantley with what I did, the value on the summary pages changes as the filters change. Any way to lock the subtotal on the summary page based on the filter criteria?

 

[Fluff]

Can you please post the formula, not an image of it.

 

[therichterscale]

=-SUMIFS(Sheet1!G3:G594,Sheet1!E3:E594,"Tuition - Preschool 5 Full Days", Sheet1!E3:E594, "Tuition - Preschool 5 Half Days", Sheet1!F3:F594,"Discount - Annual")

Can you please post the formula, not an image of it.

Does it have something to do with the fact that I am searching in the same column E for similar criteria Preschool 5 Full Days and Preschool 5 Half Days? When I add the 3rd criteria, I get a 0 value, when I take out one of the two "Preschools" I can get a value. I want to capture both Preschool 5 Full and Preschool 5 Full.

 

[Fluff]

Thanks for that, as you have two conditions for a single column you need to use

=-SUM(SUMIFS(Sheet1!G3:G594,Sheet1!E3:E594,{"Tuition - Preschool 5 Full Days", "Tuition - Preschool 5 Half Days"}, Sheet1!F3:F594,"Discount - Annual"))

 

[therichterscale]

Thanks for that, as you have two conditions for a single column you need to use

=-SUM(SUMIFS(Sheet1!G3:G594,Sheet1!E3:E594,{"Tuition - Preschool 5 Full Days", "Tuition - Preschool 5 Half Days"}, Sheet1!F3:F594,"Discount - Annual"))

I really appreciate you're time walking me through this. It all worked. Thank you again!!

 

[Fluff]

You're welcome & thanks for the feedback.