Excel Forum
Similar Content
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
How to Add Formatting to Cells and Data in Excel Styles, Fonts, Colors, & More
Tutorial: In this tutorial I will cover how to use the various formatting tools in Excel. The Format...
Add Values to a ListBox
Tutorial: How to fill a Listbox with values in a UserForm. By default, a Listbox in a form will be e...

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.