dsum formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

DSUM Formula

resolvedResolved · Low Priority · Version 2003

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?

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

RE: DSUM Formula

Will try this thanks

RE: DSUM Formula

Hi Nasif

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

Amanda


 

Excel tip:

Highlighting a data range

Attempting 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!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




View all Excel hints and tips


Server loaded in 0.11 secs.