The 2 Most Important Excel Functions AND
AND

Lesson 9: Excel Spreadsheets Statistical Functions (83)In annex 9 you have found a description of all 83 Excel functions in the "Statistical" category. Below is the list of the 7 most useful ones. See more on the obsolete function COUNTIF in lesson 14, more on the MIN, MAX, SMALL, LARGE functions LARGE, SMALL And what if you want the second or third largest value or the second smallest value. Use LARGE and SMALL like this: As a matter of facts you can forget about MIN and MAX with: COUNT and COUNTA If you want to count the number of cells that are not blank COUNT and COUNTA will return a different result if in one of the cells there is a text. OR A SPACE AVERAGE and AVERAGEA Watch for dates! If you want the average of a range and there is a date within there is a problem because dates are numbers. If all the cells are dates, indeed you can calculate the average date of.... The difference between AVERAGE and AVERAGEA becomes evident when one of the cells contains a text OR A SPACE and don't forget the SPACE. A cell containing a space is NOT empty.

SUMPRODUCT ¦
INDEX/MATCH ¦
SUBTOTAL ¦
ISERROR ¦
HLOOKUP ¦
LOOKUP ¦
VLOOKUP
COUNTIF ¦
SUMIF ¦
IFERROR