Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can DSUM give me specific data?

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DSUM to pull data from Access DB Brian Excel Worksheet Functions 2 May 12th 09 11:21 PM
DSUM not pulling the data - why Mike Webb New Users to Excel 0 August 18th 06 09:12 PM
Give RELEVANT responses to questions. DO NOT give usless list pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM
How to make other cells give a specific value when entered into a Allen Excel Discussion (Misc queries) 2 April 11th 06 04:22 AM
Can someone give me more examples of DSUM? User Excel Worksheet Functions 2 February 16th 06 07:09 PM


All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"