Excel Forum

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

Got a Question? Ask it Here in the Forum.