In Excel 2000 I use DSUM to give me a summary, by account code, of a list of
expenses.

The formula is =DSUM(Database,$B$3,INDIRECT(HLOOKUP($A22,criterio n,4,0)))

Database is the range where all the individual items of expenditure are
listed.
$B$3 is the top of the column in the range to be summed.
The criteria section is calculated by using the specific account code in
$A$22 and looking at data in row 4 of a tab called "criterion".

In this tab row 4 has a formula
="criteria!"&ADDRESS(2,COLUMN())&":"&ADDRESS(3,COL UMN())

This formula creates a 2 cell range, as required by the DSUM formula, with a
dynamic formula in the bottom cell limiting the search criteria to a single
account code.

It worked perfectly in Excel 2000. Can anyone help me make it work in Excel
2007.