Use of the DSUM formula to find exact matches in datatables

R

Rob Henson

I am using DSUM formula in Excel 2002 to summarise data relating to Material
stock lines but it currently will not distinguish parts that have similar
starting part numbers. I have replicated the Orchard scenario in the Help
and it does not appear to work. If you change one of the lines in the data
area to show 'Apples' instead of 'Apple', it does not change the result of
the DSUM; even changing it to 'Apple Trees' does not change the result. Is
there something wrong with the function, has it been fixed in later versions
of Excel? The exact match is very important in my work as part no ABC-123
could be very different to part number ABC-123A but the DSUM formula
recognises them as the same.
 

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

Similar Threads

DSUM Criteria - find exact match only 1
Criteria field in dsum formula 2
Old DSUM formula not working in Excel 2007 0
Using VLOOKUP results in a DSUM criteria range 2
Using DSUM to get running total on a filtered form 0
MS Project. Real progress of the project, % complete 1
Embed the same Excel multiple times 0
DSUM Not Very Convenient 2

Top