Howdy All,

I'm trying to sum data contained in an Access DB based on multiple criteria.

DB name = FTD.mdb
location = c:\FTD.mdb

I'm trying to sum Labor hours (which are in a column labels 'Labor) for a
specific 'Manager' (column name) and specific 'Assignee' (column name).

Criteria entered in A1:B2
A B
1 Manager Assignee
2 Flintsone, Fred Rubble, Barney

Formula I have tried =DSUM("C:\FTD.mdb","Labor",A1:B2)

I'm getting the generic "The formula you typed contains an error." and it
highlights my criteria range.

Have I overlooked something simple (which I usually do)?

Thanks,
Brian