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