Use of the DSUM formula to find exact matches in datatables

G

Guest

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
DSUM - Modifying the function... 1
DSum function 2
DSUM Criteria and Excel Help 3
Formula (or code) return the largest number of duplicates in a list. 16
Converting Lotus 1.2.3 V5 DSUM function with multiple conditions to Excel 3
Alternative to calc differences of DSUM functions (with 5 or 6 criteria) 3

Top