Excel Macros

Excel functions, formulas and examples

 

Excel tips on functions and formulas

Excel Functions and Formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

Special

Excel Functions

2003

 

sumproduct

index-match

subtotal

iserror

countif

sumif

hlookup

lookup

vlookup

 

 

Special

Excel Functions

2007

 

averageif

averageifs

countifs

sumifs

iferror

 

 

 

 

 

 

 

Before you start looking for a solution using macros (VBA)

Discover the almighty SUMPRODUCT Function in Excel


If you  already use SUMPRODUCT in most of your workbooks
If you use SUMPRODUCT in your powerful automated reporting spreadsheets
Then you can start discovering

VBA for Excel (Macros)


Excel Functions and Formulas Sitemap

Downloadable Tutorials, Examples and Templates

 

 

Excel tips on functions and formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  COUNTIF  ¦  SUMIF  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS  ¦  COUNTIFS  ¦  SUMIFS  ¦  IFERROR