Formulas & Functions

SUMIF Function

June 28, 2015 0

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

Excel Is Fun

Excel Magic Trick 1085

January 9, 2015 0

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

Dueling Excel

Dueling Excel 005

January 6, 2015 0

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