Subtotal & sumifs

zJenkins

Board Regular
Joined
Jun 5, 2015
Messages
144
I'm trying to Subtotal a series of SUMIFS functions.

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

Code:
=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:

Code:
=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.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,989
Members
409,553
Latest member
alscno

This Week's Hot Topics

Top