Thread: How can DSUM give me specific data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How can DSUM give me specific data?
In your criteria region, use

="=MAB126"
instead of
MAB126

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Mon, 4 Jan 2010 14:11:01 -0800, evergreenstar
wrote:

How can DSUM give me specific data?

MAB126 50
MAB1261 100

When I add MAB126 in the DSUM field, it sums the two for a total of 150.
Reply With QuoteReply With Quote