You can't select only the second criteria in the criteria area. You
could set up a new criteria area for the DSUM, with only the entry that
you need.
lxnv wrote:
two entries for criteria
how do I isolate the second entry when I utilize the dsum() function? I can
only sum the values for both entries.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html