H
Hansard
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,criterion,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,COLUMN())
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.
expenses.
The formula is =DSUM(Database,$B$3,INDIRECT(HLOOKUP($A22,criterion,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,COLUMN())
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.