Photo Gallery

Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard
Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets
Excel Magic Trick 406: Add 1 Extra For Each Deposit
Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arrays
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT
Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)
Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take
Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)