Excel 2000 DSum Function

J

J Chew

Basic Dsum function is DSUM(database,field,criteria)

I have 2 criteria headed as Names i.e. to sum when the
first name is "AM" and the other "AMB".

When using Dsum it does not make two distinct summing but
add this two sums together especially the one named "AM".
The one named "AM" sums both AM and AMB together? The one
named "AMB" seems to sum up correctly but not the "AM"

How do I resolve this when the names used within the
criteria are quite similar but yet different?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top