Excel Forum
Similar Content
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...

Highline Excel Class 30: SUMIF, RANK & Bonuses

Topics for this video:
1)SUMIF function to add with one criteria
2)RANK function to rank the highest to lowest (one to five)
3)IF function to assign a bonus
4)Boolean Logic TRUE FALSE formula to assign a bonus
5)Formula Evaluator for Boolean Logic Formula
6)See how to use Excel Table Formula Nomenclature in formulas
7)Custom Number formatting for Formula Inputs

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.