O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Database Functions with Tables

As you saw in Chapter 6, Excel contains 12 database functions for use with tables. Each of these functions requires three arguments:

  • database. This argument tells the function which database or table to use. You can specify database as either a range (for example, A1:F4) or by the table's name (for example, “Customer_Sales”).
  • field. This argument tells the function which field in the database you're interested in. For example, you could specify "State" to use the field named State.
  • criteria. This argument tells the function the range in which to find the criteria for the comparison. The range must have at least one column label and at least one cell under the column label; this is where you specify the condition. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required