Forum home » Delegate support and help forum » Microsoft Excel Training and help » DSUM Formula

DSUM Formula

ResolvedVersion 2003

Wed 28 May 2008, 14:21 Delegate 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:56 Trainer 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:18 Delegate Nasif said...