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:
My formula looks like this =DSUM(DB,19,C56). 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.