This is an excerpt from Pierre Leclerc (www.excel-vba.com)

Excel functions and formulas

 

The 2 Most Important

Excel Functions AND
Formulas

 

SUMPRODUCT

AND

INDEX/MATCH

 

 

Annex 1: Excel Spreadsheets  Database Functions (12)

There are 12 functions in the "Database" category. All of them are rarely used.

Frequency * Functions What it Does
Rarely Used DAVERAGE  Returns the average of selected database entries
Rarely Used DCOUNT Counts the cells that contain numbers in a database
Rarely Used DCOUNTA  Counts nonblank cells in a database
Rarely Used DGET Extracts from a database a single record that matches the specified criteria
Rarely Used DMAX Returns the maximum value from selected database entries
Rarely Used DMIN Returns the minimum value from selected database entries
Rarely Used DPRODUCT Multiplies the values in a particular field of records that match the criteria in a database
Rarely Used DSTDEV Estimates the standard deviation based on a sample of selected database entries
Rarely Used DSTDEVP Calculates the standard deviation based on the entire population of selected database entries
Rarely Used DSUM Adds the numbers in the field column of records in the database that match the criteria
Rarely Used DVAR Estimates variance based on a sample from selected database entries
Rarely Used DVARP Calculates variance based on the entire population of selected database entries

 

 

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

 

 

 

 

left arrow Back home