Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 2. Database Functions > mmDBAVG

Business Formulas

mmDBAVG

Category: Database Analysis

The database formula mmDBAVG returns the average of values of a variable item selected according to two other variables from the same dataset. Database formulas can be used to make bivariate tables. They work like the Pivot Table tool of Excel, but make the construction of custom tables more flexible.

Syntax

mmDBAVG(Label1, Column1, Label2, Column2, Search_Column, Database)

Label1 The first text label to search for
Column1 The column to search for the first text label
Label2 The second text label to search for
Column2 The column to search for the second text label
Search_Column The column to extract data from
Database The whole range where the data is stored

Example

See example file Business Formulas.xls, sheet mmDBAVG.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmBASS
  • mmCHIp
  • mmCODING
  • mmDBCOUNT
  • mmDBSUM
  • mmDHMS
  • mmSIGNIF
  • mmBEP
  • mmBEPR
  • mmCAGR
  • mmCSII
  • mmCSIW
  • mmEI
  • mmPERFCV
  • mmPERFO
  • mmPERFR
  • mmRANK
Related MM4XL software tools
  • CrossTab
  • Sample Manager
  • Proportion Analyst
  • Brand Mapping
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: