Photo Gallery

Excel Magic Trick 1247: Adding with Case Sensitive Criteria: EXACT & SUMPRODUCT
Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template
Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula
Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)
Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment
Excel Magic Trick 848: Create List of Dates For Month With Formula
Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)
Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter
Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT
Excel Magic Trick 406: Add 1 Extra For Each Deposit
Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function
Excel Magic Trick 788: Add Numbers After Last Zero