|
Featured Tutorial
Featured Macro
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
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