Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DSUM Formula (Excel 2000 SR1)

    I'm trying to use the DSUM formula with a rather large database....and it's not working. I'm pretty sure I have the syntax right. My database is a named range called "DB", the column I want to sum is the 19th column in the range, and criteria consisting column header (in this case "Type") and the specific criteria (in this case "10") is contained in C5 and C6

    My criteria range looks like this:

    Type
    10

    My formula looks like this =DSUM(DB,19,C56). I've also tried =DSUM(DB,"SERVICE",C5:C6)...with the same result...a #VALUE error. What am I doing wrong?

    My database and the DSUM formula are on different sheets...is that a problem?

    Thanks in advance for your help.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: DSUM Formula (Excel 2000 SR1)

    Database on a different sheet than =DSUM(,,) formulas should not be a problem. Are you certain there are no Excel errors (such as #VALUE) in the database field name being summed? If not, can you post a censored example of the Workbook?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DSUM Formula (Excel 2000 SR1)

    <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

    one thing to double check is that the named range is actualy looking where you think it is, as looking outside of the range would give an #VALUE error

    Peter

Posting Permissions

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