Content Analysis: Download Files: Entire page with all

Photo Gallery

Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special"
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT
Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data)
Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters
Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples)
Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?
Excel Magic Trick 1163: COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too.
Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?
Excel Magic Trick 1472: Count Between (or Above and Below) Upper & Lower Limits (7 Examples)
Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603
Excel Magic Trick 1214: How To Enter Text Criteria Into Excel Database Functions