dsum criteria problem

G

Guest

I have criteria SRM and SRM-NT (payroll codes) in table - dsum finds value for both instead of only SRM-NT which has values in table (SRM has no values) - also if SRM does have values in table, dsum picks up value for SRM plus values for SRM-NT and then SRM-NT shows correct value - sometimes I have been able to erase results in dsum results field, reenter formula and then correct values will appear - but not always - does anyone else have this problem when criteria contain same letters? Thanks for any assistance
 
D

Debra Dalgleish

Change your criteria to: ="=SRM"

I have criteria SRM and SRM-NT (payroll codes) in table - dsum finds value for both instead of only SRM-NT which has values in table (SRM has no values) - also if SRM does have values in table, dsum picks up value for SRM plus values for SRM-NT and then SRM-NT shows correct value - sometimes I have been able to erase results in dsum results field, reenter formula and then correct values will appear - but not always - does anyone else have this problem when criteria contain same letters? Thanks for any assistance
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSUM Basics 1
Conditional Sum - variable criteria 5
DSum criteria 2
How do i assign a null value to a cell in Microsoft Excel? 1
Using the function DSUM 7
DSUM search issues 1
dsum 4
use multiple combo boxes to filter table, results displayed in sub 17

Top