Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dsum function (Excel 2000)

    When doing a DSUM worksheet function, the CRITERIA range that you have to include in the worksheet function, creates acculumated values of all the lines included in the criteria items. The obvious solution is to deduct the cumulative value of the previous lines, but this is cumbersome if you have a long list of criteria. I have attached a file for you perusal indicating the duplication problem.
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: dsum function (Excel 2000)

    The problem with your sample sheet is with the Criteria range - It is different for both cases, A1:A2,for a, and A1:A3 for b. What it is doing in the second case is giving you the result of a OR b . When you list you criteria in a column, it is taken as OR.

    If what you want is a summary of subtotals for all records, I would suggest a Pivot Table, or a SUMIF formula. You could use the DSUM, function but it would be cumbersome, as you would have to have column for each case and then you would still have to define separate criteria ranges.

    I attach you workbook with samples of the possible alternatives.

    Andrew C
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •