On Aug 1, 11:59*am, "Jim Rech" wrote:
There are two changes you have to make to get DSUM to work. First, change
your criteria from the literal "ABC123" to a formula like =A2="ABC123" where
A2 is the first data cell in the Rep column of your database. *Second, clear
the "Rep" header in the first cell of your criteria range. *This cell should
be empty (but included in the Criteria range).

wrote in message

...







I am using an advanced filter to copy a list and then using the DSUM
function to sum all the appropriate fields I would like. *However, I
believe there is a problem with the DSUM function as I am using it.
The data looks similar to the sample data below. *The probelm occurs
when there are two fields similar to each other, such as "ABC123" and
"ABC123D" which appear separate on the list using advanced filter, but
the after checking the data, the amounts for "ABC123D" are included in
"ABC123". If there is a way for the DSUM function, or another function
to read exact variables, and not so inclusive, that is what I am
looking for. *There are more than one occurrence of this problem, so I
cannot list it out individually (i.e, "ABC123" & "ABC123D" also
"DEF123" & "DEF123S") since there are over a dozen cases in my file.
If there is a better way to do this without using a pivot table,
please let me know, any help is greatly appreciated.

Rep Sales Comm
ABC123 * * * * * * 500 100
DEF123 * * * * * * 400 50
HIJABC * * * * * *480 80
ABC123D * * * * * *100 20
DEF123S * * * * * *200 50
GEF456 * * * * * *800 120
ABC123 * * * * * *300 75

Could you just use =SUMPRODUCT(((