98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » DSUM Formula
DSUM Formula
Resolved · Low Priority · Version 2003
Wed 28 May 2008, 14:21Delegate Nasif said...
Nasif has attended:
Excel Advanced course
DSUM Formula
I have a problem with this formula when I put in the criterion for similar names.
For eg in the following example the criterion is similar ;
Jamie
Jamie OB
The dsum formula for the first 'Jamie' picks up all data with both names while the second one with 'Jamie OB' does the right thing.
Any ideas?
Thu 29 May 2008, 14:56Trainer Amanda said...
RE: DSUM Formula
Hi Nasif
Thank you for your question.
Have you tried using the Subtotals feature instead, as this may help you to get the correct totals from your data?
Kind regards
Amanda
Thu 29 May 2008, 16:18Delegate Nasif said...
RE: DSUM Formula
Will try this thanks
Thu 29 May 2008, 16:37Trainer Amanda said...
RE: DSUM Formula
Hi Nasif
A further thought, you could probably use the SUMIF function to get the results you want as well.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting a data rangeAttempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own! |
