Excel Is Fun

Excel Magic Trick 1182

COUNTIFS and Wildcards to Count When There are 4 or More Characters DESCRIPTION See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz [Read More >>>]

Excel Is Fun

Excel Magic Trick 1181

Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT DESCRIPTION See how to: (00:08) Count numbers with 4 or more characters using COUNTIFS function. See that COUNTIFS requires Comparative Operators in Double [Read More >>>]

Excel Is Fun

Excel Magic Trick 1178

Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA? DESCRIPTION From Survey Results, see examples of how to calculate the percentage of No responses given that the response was from a Full Time Faculty in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1172

Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT DESCRIPTION See how to: (00:38) INDEX and MATCH functions to lookup a column (00:50) Highlight non-contiguous ranges using Ctrl (03:13) Enter Formula into non-contiguous ranges using [Read More >>>]

Excel Is Fun

Excel Magic Trick 1166

Count Dates From Date-Time Values: COUNTIFS or PivotTable? DESCRIPTION See how to Count Dates From Date-Time Values: COUNTIFS or PivotTable: (00:00) Look back to EMT 1163 to look at SUMPRODUCT and INT formula (00:45) COUNTIFS [Read More >>>]

Excel Is Fun

Excel Magic Trick 1163

COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. DESCRIPTION See how to: (00:10) COUNTIFS with Date Criteria that is matched up against a column with Data Times will not work. (00:55) Examine [Read More >>>]

Excel Is Fun

Excel Magic Trick 1156

Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods) DESCRIPTION See how to Count the “N” (New) and “U” (Used) for Each Sale (00:08) Problem Setup (01:08) Two COUNTIFS functions with Mixed [Read More >>>]

Excel Is Fun

Excel Magic Trick 1146

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check [Read More >>>]

Dueling Excel

Dueling Excel 027

COUNT w More Than 1 Criteria 10 Examples! DESCRIPTION See Mr Excel and excelisfun use 10 different methods for counting with more than 1 criteria. See the functions: SUMPRODUCT w multiplying, SUMPRODUCT w double negative, [Read More >>>]