Old DSUM formula not working in Excel 2007

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top