DSUM Formula (Excel 2000 SR1)

Topic

New Reply

I’m trying to use the DSUM formula with a rather large database….and it’s not working. I’m pretty sure I have the syntax right. My database is a named range called “DB”, the column I want to sum is the 19th column in the range, and criteria consisting column header (in this case “Type”) and the specific criteria (in this case “10”) is contained in C5 and C6

My criteria range looks like this:

Type
10

My formula looks like this =DSUM(DB,19,C5:D6). I’ve also tried =DSUM(DB,”SERVICE”,C5:C6)…with the same result…a #VALUE error. What am I doing wrong?

My database and the DSUM formula are on different sheets…is that a problem?

Thanks in advance for your help.

Reply | Quote

Replies

Database on a different sheet than =DSUM(,,) formulas should not be a problem. Are you certain there are no Excel errors (such as #VALUE) in the database field name being summed? If not, can you post a censored example of the Workbook?

Reply | Quote

one thing to double check is that the named range is actualy looking where you think it is, as looking outside of the range would give an #VALUE error

Peter

Reply | Quote