### Dueling Excel 149

July 5, 2017

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

### Dueling Excel 142

May 17, 2017

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

### Excel Magic Trick 1285

April 6, 2017

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

### Dueling Excel 126

January 25, 2017

DESCRIPTION SUM Daily Totals from Text Dates with Text Day Criteria See Mr Excel and excelisfun use two methods to 1. Add up daily sales from a template that is not setup properly: multiple columns […]

### Dueling Excel 55

December 16, 2015

Calculate Grade & Exclude Scores When Student Is Absent DESCRIPTION See Mr Excel and excelisfun use SUMPRODUCT, ISNUMBER, and SUMIF functions to calculate a grade where excused absences are considered in final grade. WORKBOOKS

### Dueling Excel 050

November 11, 2015

#N/A errors SUMIF or AGGREGATE? DESCRIPTION See Mr Excel and excelisfun create formulas to add a column of numbers and ignored the #N/A error: SUMIF function or AGGREGATE function? WORKBOOKS

October 23, 2015

WORKBOOKS

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

### SUMIF Function

June 28, 2015

DESCRIPTION You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example. Suppose that in a column that contains numbers you want to sum only the […]