Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem […]
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 […]
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 […]
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
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. […]
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, […]
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 […]
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.