THE Ultimate  Excel Portal         LINKS:  [ Popular | New | Editor's Picks | Top Rated ]
Home >> Previous Page >> Using DSUM for Conditional Summation (link details)
Main Categories
Excel Add-ins
Excel Help
Excel Password Recovery
Excel Templates
Excel Tips & Tricks
Excel Tutorials
Excel VBA
Free Excel Add Ins
Spreadsheet Research
Create Excel Dashboard Reports with Plug-N-Play Reports
Newest Links
ExcelArt
MiniCharts
Production Planning and Scheduling
Interactive Spreadsheet Guide
QueryCell
Kinematics
OpenSystems21
Docstoc.com
Google Docs
TodoExcel

Using DSUM for Conditional Summation

Domain: www.grbps.com
Categories: Excel Database

This article explains how to use the DSUM database function in Excel instead of complicated nested SUM and IF formulas. [PDF Format]

Rating: 4.18 (11 votes)
Added: 06-02-2004 - Updated: 06-03-2004 - Comments: 0 - Hits month/total: 60/9278
Report error

Version (if applicable): 97/2000/2002(XP)/2003
Rate This Link
Extremely Satisfied
Satisfied
Neutral
Confused
Disappointed

An introduction to the D-functions and how these can overcome some serious problems experienced when over-using array formulae in Excel.


Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.
© 2003, 2004 Vertex42, LLC All rights reserved.
 The Excel Nexus