Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: DSUM function

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have an Excel file w/ 13 worksheets - one for each month of the year and a tables worksheet at the end.

    In the worksheet titled "jan", there is a formula which reads:

    =DSUM(JAN,"G/L BAL",CATEG_RF)

    The "G/L BAL" is the column header of this formula and 'CATEG_RF' is defined in the tables worksheet.

    Problem: I've added several lines to the end of the table but the formula isn't picking up on them. The only new lines this formula will read are the ones added w/i the table rather than at the end. I need this formula to include the lines at the end of the table.

  2. #2
    New Member
    Join Date
    May 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    WHEN YOU NAMED THE RANGE 'CATEG_F', DID YOU HIGHLIGHT AN AREA OR DID YOU HIGHLIGHT THE COLUMN LABEL?

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,025
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-10 12:49, kim wrote:
    I have an Excel file w/ 13 worksheets - one for each month of the year and a tables worksheet at the end.

    In the worksheet titled "jan", there is a formula which reads:

    =DSUM(JAN,"G/L BAL",CATEG_RF)

    The "G/L BAL" is the column header of this formula and 'CATEG_RF' is defined in the tables worksheet.

    Problem: I've added several lines to the end of the table but the formula isn't picking up on them. The only new lines this formula will read are the ones added w/i the table rather than at the end. I need this formula to include the lines at the end of the table.
    Kim,

    Would you please post that table or a portion of it if it's too big?

    If inclined to do so, please use the following procedure:

    Select an empty cell, type =, select the table or the upper portion of it, hit F9, Edit|Copy what you see, and post the copied bit in the follow up here.

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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