Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Use of the DSUM formula to find exact matches in datatables
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. |
#2
|
|||
|
|||
In the criteria cell, instead of typing: Apple
type: ="=Apple" Rob Henson wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND formula that searches from right? | Excel Worksheet Functions | |||
Formula to find information between 2 dates | Excel Worksheet Functions | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
Can you help to find the right formula? | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |