You are browsing Vertex42's directory of Excel websites and resources. Browse Vertex42's Excel Templates
:: Examples and tutorials for using an Excel database. Excel database functions include DCOUNT, DSUM, DGET, and DAVERAGE to name just a few.
:: An Excel List can be used as a database, and you can get really fancy by using external data. Pivot tables can be used to summarize data in a database. All these advanced techniques are just begging for tutorials!


Using DSUM for Conditional Summation   www.grbps.com
This article explains how to use the DSUM database function in Excel instead of complicated nested SUM and IF formulas. [PDF Format]
Added: 06-02-2004 - Updated: 06-03-2004 - Hits total: 10391

Similar Categories
Pivot Tables