Formula Mismatches

[daver676]

Hello

I have a formula (DSUM) I use in order to calculate parts
to be shipped on a certain date. The problem is I have 2
similiar part numbers. one is 3274329340 and the other is
3274329340AWM. The formula cannot distinguish the
difference between the 2 part numbers. How can I make the
formula distinguish between the two part numbers, without
having to actually change the part numbers?

Thanks

Dave

 

[Bob Umlas]

Make the criteria be
="=3274329340" instead of 3274329340 -- then only whole cells will be used
for the DSUM.


A live, online Excel Master Class is starting in September (which I'm
teaching).
For details, please follow this link:

http://www.iil.com/str_link_all_results.asp?select_cartid=395


Bob Umlas
Excel MVP