DSUM function

[kim]

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.

 

[mapakunk]

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

 

[Aladin Akyurek]

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