The 2 Most Important Excel Functions AND
AND

Excel Functions and Formulas SitemapThis website is divided in 4 sections: Section 1: Useful Excel Functions by Category
Section 2: Special Excel Functions
Section 3: Other Pages on Excel Functions and Formulas
Section 4: Annexes on All Functions by Category
The most useful and powerful function in Excel

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