Hi! 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. CHV
Charles H Van deZande
<<faint_grain.jpg>>
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
