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]

You can use the sumifs function for that How to use the Excel SUMIFS function | Exceljet

 

[therichterscale]

Will it matter if using filters?

 

[Fluff]

It will calculate all values that match the criteria you specify.

 

[therichterscale]

I'm getting an error, it won't capture. When entering the Criteria, given everything is on sheet 1, do have to add sheet1! in front of the criteria - Elementary and Discount - Multi Child?

=sumifs(Sheet1!G3:G594,Sheet1!E3:E594,Sheet1! - Elementary,Sheet1!F3:F594,Sheet1!"Discount - Multi Child")

 

[therichterscale]

I'm getting an error, it won't capture. When entering the Criteria, given everything is on sheet 1, do have to add sheet1! in front of the criteria - Elementary and Discount - Multi Child?

=sumifs(Sheet1!G3:G594,Sheet1!E3:E594,Sheet1! - Elementary,Sheet1!F3:F594,Sheet1!"Discount - Multi Child")

I think I got it except there is no value.

=SUMIFS(Sheet1!G3:G594,Sheet1!E3:E594,"Sheet1! Tuition - Elementary",Sheet1!F3:F594,"Sheet1! Discount - Multi Child")

 

[Fluff]

It should be like

=SUMIFS(Sheet1!G3:G594,Sheet1!E3:E594,"Tuition - Elementary",Sheet1!F3:F594,"Discount - Multi Child")

 

[therichterscale]

It should be like

=SUMIFS(Sheet1!G3:G594,Sheet1!E3:E594,"Tuition - Elementary",Sheet1!F3:F594,"Discount - Multi Child")

Thank you, looks like I have a value and it matches the other sheet 1.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[therichterscale]

Glad to help & thanks for the feedback.

Sorry one more question, I'm adding a third criteria, its not grabbing the values.

Summary

Sheet 1