Excel Magic Trick 1472

DESCRIPTION Learn about how to Topics: (00:11) Introduction (01:58) Ex 1: Between Upper & Lower Limits: =COUNTIFS Function (04:45) Ex 2: Between Upper & Lower Limits: =DCOUNT Function (07:00) Ex 3: Between Upper & Lower [Read More >>>]

Excel Magic Trick 1217

D Functions: Text Criteria: “Starts With”, “Exact” and “Contains” DESCRIPTION For Text Criteria in D Functions (Like DSUM, DCOUNT, DMAX) learn about the difference between: “Starts With”, “Exact” and “Contains” Criteria. (00:10) Problem Setup (00:47) [Read More >>>]

Excel Magic Trick 1197

OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT? DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, [Read More >>>]

Dueling Excel 020

DESCRIPTION See Mr Excel and excel is fun summarise survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting [Read More >>>]

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 >>>]

Highline Excel 2013 Class Video 12

DESCRIPTION Topics in this video: (00:32) D Functions. (01:20) AND Criteria for DCOUNT, DSUM, DAVERAGE, DSTDEV (05:50) OR Criteria for DSUM (07:02) AND and OR Criteria for DSUM WORKBOOKS