Excel Databases

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using Microsoft Excel
databases.

Use SUMIF instead of D... functions When you need to analyze a list of data then you can set up criteria ranges and use database functions like DSUM, DAVERAGE or DCOUNT - OR, take a shortcut and use SUMIF and COUNTIF. These functions have built in criteria ranges, so you save time. =SUMIF(C16:C:45,"10.2",G16:G45) will sum all the... Keywords: Criteria, DAVERAGE, DCOUNT, COUNTIF

ExcelUser, Inc.

http://www.ExcelUser.com

Copyright © 2004 - 2009 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.