DSUM error VALUE 1

[Bronte1226]

I am trying to use the database function DSUM to calculate a field. The database is on a seperate sheet (called "Database" and given the named range or "Database") The criteria that I am using to filter the summation is on another sheet called "Database Criteria". The named range I am using is called "CritPerf1" it has the same layout as the database as far as the heading structure (as follows)

Emp SSN Emp Name Performance Level Base Pay Raise Percentage Raise Amount Bonus Amount Adjusted Base Pay

I am doing it this way to be able to change the critera to filter by on the fly. In my field on another sheet named "summary" I have a field to sum all of the raises. The raise column has been named "raise" (data portion only) so the formula I am using is this:

=DSUM(Database,"Raise",CritPerf1)

This is returning a "#VALUE!" result. I have tried deleting the named ranges and redefining them, which did not change anything. I have even rebuilt the entire workbook 4 times, but something I am doing is keeping this from working. Please help!

Thanks!

 

[SkipVought]

Hi,

Use Column Heading Value...
[tt]
=DSUM(Database,"Raise Amount",CritPerf1)
[/tt]


Skip,

_[red][/red]

 

[Bronte1226]

That is it! Thanks a ton Skip!