### Excel Magic Trick 1171

October 22, 2015

SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead DESCRIPTION See how to add for Text Number Criteria such as 0500 and 00500 using SUMPRODUCT rather than SUMIFS or SUMIF: (00:08) Problem […]

### Dueling Excel 044

October 7, 2015

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and […]

### Excel Magic Trick 1166

October 5, 2015

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

### Dueling Excel 043

September 30, 2015

End Inventory Value From Transactional Records SUMPRODUCT SUMIF DESCRIPTION Mr Excel is on hiatus to finish his new Excel 2010 books. Excelisfun shows how to calculate Weighted Average Cost Ending Inventory Value from Transactional Records […]

### Excel Magic Trick 1163

September 24, 2015

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

### Excel Magic Trick 1156

August 31, 2015

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

### Excel Magic Trick 1149

August 6, 2015

Dynamically Sum by Category without VLOOKUP Helper Column (2 methods) DESCRIPTION See how to: Dynamically Sum Costs by Category without VLOOKUP Helper Column: (00:47) VLOOKUP helper Column and SUMIFS function (03:10) Array Formula using SUMPRODUCT […]

### Dueling Excel 030

July 1, 2015

Count Bills for Money Transaction DESCRIPTION See Mr Excel and excelisfun create formula that will take a dollar amount and count how many \$100 bills, how many \$50 bills, etc. are needed for the minimum […]

### Dueling Excel 027

June 10, 2015

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, […]

### Excel 2013 PowerPivot Basics 04

April 4, 2015

DESCRIPTION See two examples of Array Formulas and two examples of PowerPivot DAX formulas that count unique values in a column (Distinct Count) and compare and contrast: (00:09) Array Formula For counting unique values using […]