Dueling Excel

Dueling Excel 043

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

Formulas & Functions

SUMIF Function

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

Excel Is Fun

Excel Magic Trick 1085

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a [Read More >>>]