Dueling Excel

Dueling Excel 108

SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods DESCRIPTION See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviation, Average using three methods: 1) Data Analysis Toolpak Add-in, Descriptive Statistics 2) PivotTable 3) Functions [Read More >>>]

Dueling Excel

Dueling Excel 101

Sum Numbers from Cells That Contain Both Text & Numbers DESCRIPTION See Mr Excel and excelisfun use two methods to add the numbers from cells that have both numbers and text. See these tricks: 1. [Read More >>>]

Dueling Excel

Dueling Excel 96

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 [Read More >>>]

Dueling Excel

Dueling Excel 92

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

Dueling Excel 81

Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS [Read More >>>]

Dueling Excel

Dueling Excel 68

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS [Read More >>>]

Dueling Excel

Dueling Excel 013

DESCRIPTION See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new [Read More >>>]

Dueling Excel

Dueling Excel 005

DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting [Read More >>>]

Excel Is Fun

Excel Magic Trick 1167

Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functions DESCRIPTION See how to Substitute Final Score If Greater Than Low Score using the MAX, MIN & SUM Functions. Adam Goodrich From [Read More >>>]

Dueling Excel

Dueling Excel 044

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 [Read More >>>]