|
|
|
|
|
|
|
|
|
|
|
The Most Important Excel Functions
|
Lesson 3: Excel Spreadsheets Engineering Functions (40)In annex 3 you have found a description of all 40 Excel functions in the "Engineering" category. If you are using a version of Excel earlier than 2007 you need to activate the "Excel Analysis Toolpack" to make some of the functions above available. Excel Functions and Formulas Sitemap
|
|
|
|
|
|
|
|
|
SUMPRODUCT ¦ INDEX/MATCH ¦ SUBTOTAL ¦ ISERROR ¦ HLOOKUP ¦ LOOKUP ¦ VLOOKUP
AVERAGEIF ¦ AVERAGEIFS ¦ COUNTIF ¦ COUNTIFS ¦ SUMIF ¦ SUMIFS ¦ IFERROR
