### Dueling Excel 96

August 24, 2016

LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type) DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single cell formula that will add […]

### Excel Magic Trick 1222

August 18, 2016

Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? DESCRIPTION Learn how to Create a Formula to Add Column Filled With Weights Like: 10kg, 33kg, 19kg: (00:10) Problem Setup (01:12) Customer Number […]

### Dueling Excel 92

August 10, 2016

Round Invoice: ROUND or SUMPRODUCT – ROUND DESCRIPTION See Mr Excel and excelisfun use two methods to round the amounts on an Invoice so the SUM total is correct. WORKBOOKS

### Dueling Excel 91

August 5, 2016

Rank Scores, But If Tie Award Highest Rank To The Largest Weight DESCRIPTION See Mr Excel and excelisfun use two methods to rank scores with the heights Weight: 1. See how to use RANK or […]

### Dueling Excel 87

July 20, 2016

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. […]

### Excel Magic Trick 1197

March 21, 2016

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

### Dueling Excel 69

March 16, 2016

Count Saturdays DESCRIPTION See Mr Excel and excelisfun create formulas to count Saturdays from a start date and end date. See the functions NETWORKDAYS.INTL, INDIRECT, ROW, WEEKDAY and SUMPRODUCT. See Mike Total mess up the […]

### Excel Magic Trick 1185

December 28, 2015

Calculate Standard Deviation from Frequency Distribution in Excel DESCRIPTION See how create a formula that uses SUMPRODUCT function to Calculate Standard Deviation From Frequency Distribution in Excel.

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

### Excel Magic Trick 1181

November 30, 2015

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