Mr Excel & excelisfun Trick 187: SUMIFS to add only Filtered Columns, NOT Hidden Rows

SUMIFS for Filtered Rows!?! Add Sales for Visible “Yes” Rows, Not Hidden Rows
Download workbook: http://ift.tt/2xtzKUd
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use
Topics:
1. (00:01) Dueling Song
2. (00:12) Mr Excel tries AGGREGATE function
3. (02:23) Excelisfun creates formula with SUMPRODUCT, SUBTOTAL, ROW and OFFSET.
4. (09:38) Mr Excel uses AGGREGATE in helper column and SUMIFS in adding formula
5. (11:39) Wrap up and conclusion
Excel Duel, Dueling Excel, Excel Duel 187
Related videos:
Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.