Subtotal & sumifs

[zJenkins]

I'm trying to Subtotal a series of SUMIFS functions.

I currently have a series of the following SUMIFS function in column G:

=IF(cur_month>=G$12-1,SUMIFS(amt_Jan,dpt_Jan,$A23,acct_Jan,$B23),SUM(G15:G22))

This pulls the values from another worksheet using named ranges.

At the end of column G I would like to subtotal everything:

=SUBTOTAL(9,G15:G251)

My issue is that I'm not sure how to make the SUMIFS formula act like a SUBTOTAL formula so that its value gets captured in the final Total.

Thank you for any help.

 

[DanteAmor]

Check the following examples

https://www.mrexcel.com/forum/excel-questions/998707-subtotal-offset.html

https://www.mrexcel.com/forum/excel-questions/1084284-subtotal-offset-count.html

https://www.mrexcel.com/forum/excel-questions/529865-subtotal-sumif-combination-help.html

https://www.mrexcel.com/forum/excel-questions/354156-can-you-combine-sumif-subtotal.html