DSUM Formula

The UK's most regular instructor-led training courses.
Training information: application development excel · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

DSUM Formula

Nasif has attended:
Excel Advanced course

by - delegate Nasif [6 posts] (2008 May 28 Wed, 14:21) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: DSUM Formula

by - trainer Amanda diamond contributer [1298 posts] (2008 May 29 Thu, 14:56) Reply

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

RE: DSUM Formula

by - delegate Nasif [6 posts] (2008 May 29 Thu, 16:18) Reply

Will try this thanks

RE: DSUM Formula

by - trainer Amanda diamond contributer [1298 posts] (2008 May 29 Thu, 16:37) Reply

Hi Nasif

A further thought, you could probably use the SUMIF function to get the results you want as well.

Amanda

· Crazy Things People Have Done With Excel
· Microsoft Excel's Best Kept Secret
· Creating Charts with Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks

Please browse our web site to find out more about
application development excel and other Microsoft training courses.

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips

Rate this page: