Excel Consulting

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

 

 

 

 

 

 

 

Your comments and questions are very welcome
Email: peter@excel-vba.com


Consulting Services in Excel and VBA

Excel Consulting

I can show you how to do it, I can help you to  it or I can do it for you
It is your choice


Serving clients online in USA and Canada for the past 15 years
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com

My academic and professional backgrounds are in accounting, finance and production planning.


The most useful and powerful function in Excel
SUMPRODUCT


Excel Functions and Formulas Sitemap

 

 

 

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