Using Database Functions in a List

graphics/microsoft44.gif

If you need to perform calculations in a list, you can use database functions in Excel. For example, you can use the function DAVERAGE or DSUM in a list to average or add the values in a column that match certain criteria. Each function uses three arguments (pieces of data) as shown in the following definition: =DSUM (database, field, criteria). Database is the range of cells in the list; field is the columns you want to use; and criteria is the range cells with the conditions. There are other database functions available, such as DCOUNT, DPRODUCT, DMAX, DMIN, and DSTDEV. Each function uses the same arguments.

Use the DSUM or DAVERAGE Function

graphics/one_icon.jpg

Create a data range in which the left-most column contains a unique value in each row.

graphics/tow_icon.jpg

Click the cell you want to place the function.

graphics/three_icon.jpg Type the function you want.

=DSUM( database,field,criteria ) or =DAVERAGE( database,field,criteria )

graphics/foure_icon.jpg

Press Enter.

graphics/10inf40.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net