THE Ultimate  Excel Portal     [ 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
Vertex42 Money Manager
Kaizen Excel Templates
Learn Excel VBA Easily
Employee Payroll Spreadsheet
Viral Growth Forecaster
Excel Training Guides
The Formulator
Financial Modeling Training Program
Customer Invoicing Template
Personal Debt Analyser

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: 4/9762
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-2010 Vertex42, LLC All rights reserved.
 The Excel Nexus