Main Profile

At A Glance

Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets

Download file: http://people.highline.edu/mgirvin/ SUBTOTAL Function To "De-Reference" An Array Of References. See how to Add Monday Through Friday Sales only when each day's sales (Mon to Sun) and dates are on different sheets in the workbook. See how use the WEEKDAY, SUBTOTAL, INDIRECT and SUMPRODUCT functions. See how SUBTOTAL Function can be used to "De-Reference" An Array Of References. Learn some great things from a Mr Excel Message Board Post by Domenic. Also see this video: Excel Magic Trick 735: Find Max Running Three Week Totals SUBTOTAL / OFFSET Array Formula Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
Length: 14:32

Contact

Questions about Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets

Want more info about Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question