3:46Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)excelisfun5.1K viewsView & Download
6:00Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excelexcelisfun15.8K viewsView & Download
2:43Excel Magic Trick 726: Count 1 For Each Item in List 1 That Is In List 2 No Double Count for Dupsexcelisfun6.9K viewsView & Download
4:53Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = "Special"excelisfun5.8K viewsView & Download
5:41Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849excelisfun24.7K viewsView & Download
4:26Excel Magic Trick 830: No Duplicates Allowed In Row, Data Validation Custom Logic Formula COUNTIFexcelisfun16.9K viewsView & Download
3:12Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell Referencesexcelisfun8.0K viewsView & Download
6:38Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Testexcelisfun9.1K viewsView & Download
4:57Excel Magic Trick 723: COUNTIF Error With Workbook References, Use SUMPRODUCT Insteadexcelisfun7.8K viewsView & Download
5:26Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?excelisfun31.0K viewsView & Download
4:17Excel Magic Trick 350: Conditional Format Values Listed 3 Times COUNTIF function Trickexcelisfun9.4K viewsView & Download
6:57Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCTexcelisfun4.0K viewsView & Download
10:01Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formulaexcelisfun5.1K viewsView & Download
14:14Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?excelisfun22.9K viewsView & Download
12:28Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?excelisfun11.6K viewsView & Download
5:58Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?excelisfun11.5K viewsView & Download