Microsoft® Excel® 2010 Formulas & Functions Inside Out

Arguments in Database Functions

Because all database functions—except the GETPIVOTDATA() function—have the same arguments, these functions will be explained at the beginning of this chapter. For database functions, you have to specify three arguments:

• database The database argument specifies the cell range that makes up the list or database. In the example used in this chapter, the range A1:F7008 has been given the range name Database.

• field The field argument indicates which column is to be used in the function. Enter the column label enclosed in quotation marks, as in “country/region”, “sales”, or “company”. You can also enter a number that represents the position of the column within the list, such as 1 for the first column or 2 for the second ...