Excel Forum
Similar Content
Sum a Range with Errors in Excel
Tutorial: How to sum a range of cells that contains errors. This requires an array formula, so it w...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...

YTL Excel #125: Array Formula w IF & AVERAGE functions

See how to create an Array Formula using the IF & AVERAGE functions to calculate bowling averages that require multiple criteria.

Got a Question? Ask it Here in the Forum.