I'm trying to use some database functions (DSUM, DMIN, DMAX, etc.). I've identified the database, and the criteria using named ranges, but it just doesn't seem to recognize the criteria. Even spelling out the ranges doesn't work.
I've got another workbook that I made last week and the functions all work normally, but I'll be damned if I can't figure out what's wrong with the one I'm working on.
Any ideas? I'm bettting it's something simple I left off.
As an added bonus, the "Advanced Filter" seems to be ignoring the criteria cells also.
Oh... and it's Excel 2003.
