Database Functions

I'm working with a database that contains descriptions of sport shoes (walking, running, etc).  I am trying to count the number of brown shoes with prices > $90, for example.  The function I'm using is
=DCOUNTA(address of datablock, column "Cost", address of criteria).  The address of the criteria block is H1:J2 where H1:J1 contains Color and Cost; H2:J2 contains Brown and >90.  I've tried it with quotes and no quotes around the labels and I keep getting the error "#NUM!".
Thanks for any suggestions.
Charles H Van deZande

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]