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.
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.