mgirvin
Well-known Member
- Joined
- Dec 15, 2005
- Messages
- 1,236
- Office Version
- 365
- Platform
- Windows
Dear Amazing World MrExcel Team,
I have a DSUM formula that seems to work with the field item "NorthEast", but it seems to add incorrectly when I use "North".
Here is the situation that adds correctly:
=DSUM(A1:E5000,”Sales”,G8:K9)
Where G8:K9 looks like this:
Region SalesRep Customer
NorthEast Luke The Economist
Here is the situation that adds incorrectly
=DSUM(A1:E5000,”Sales”,G8:K9)
Where G8:K9 looks like this:
Region SalesRep Customer
North Luke The Economist
Any ideas about what is going on?
I have a DSUM formula that seems to work with the field item "NorthEast", but it seems to add incorrectly when I use "North".
Here is the situation that adds correctly:
=DSUM(A1:E5000,”Sales”,G8:K9)
Where G8:K9 looks like this:
Region SalesRep Customer
NorthEast Luke The Economist
Here is the situation that adds incorrectly
=DSUM(A1:E5000,”Sales”,G8:K9)
Where G8:K9 looks like this:
Region SalesRep Customer
North Luke The Economist
Any ideas about what is going on?