Content Analysis: Download Files: See how to use the

Photo Gallery

Excel Magic Trick 658: COUNT Vs. COUNTA function
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)
Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)
Excel Magic Trick 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF
Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records?
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
Excel Magic Trick #181: Count Words Case Sensitive
Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?
Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions