ExcelBanter - How can DSUM give me specific data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can DSUM give me specific data? (https://www.excelbanter.com/excel-discussion-misc-queries/252381-how-can-dsum-give-me-specific-data.html)

evergreenstar

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.

Chip Pearson

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.

All times are GMT +1. The time now is 05:12 AM.