Aces High Bulletin Board

General Forums => The O' Club => Topic started by: Sandman on September 20, 2005, 07:48:59 PM

Title: Excel Question
Post by: Sandman on September 20, 2005, 07:48:59 PM
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.

:huh


Oh... and it's Excel 2003.