Have you tried =DCOUNTA(address of datablock,H1:J1,H1:J2)
On Wed, Feb 11, 2009 at 6:00 AM, <[email protected]> wrote: > Send gnumeric-list mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://mail.gnome.org/mailman/listinfo/gnumeric-list > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnumeric-list digest..." > > > Today's Topics: > > 1. Database Functions (Charles Van deZande) > 2. Re: Database Functions (Andreas J Guelzow) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 10 Feb 2009 10:18:23 -0500 (Eastern Standard Time) > From: "Charles Van deZande" <[email protected]> > Subject: Database Functions > To: <[email protected]> > Message-ID: <49919abe.00000f.03...@charles-pc> > Content-Type: text/plain; charset="utf-8" > > 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 > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://mail.gnome.org/archives/gnumeric-list/attachments/20090210/dfe2f1fa/attachment.html > > > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: not available > Type: image/jpeg > Size: 1458 bytes > Desc: not available > URL: < > http://mail.gnome.org/archives/gnumeric-list/attachments/20090210/dfe2f1fa/attachment.jpe > > > > ------------------------------ > > Message: 2 > Date: Tue, 10 Feb 2009 09:02:42 -0700 > From: Andreas J Guelzow <[email protected]> > Subject: Re: Database Functions > To: [email protected] > Message-ID: <1234281762.20038.8.ca...@localhost> > Content-Type: text/plain > > On Tue, 2009-02-10 at 10:18 -0500, Charles Van deZande wrote: > > 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 > > > > > > > > > > > > > I am not quite sure I understand what you are doing. You may have to be > a bit more explicit, but the criteria should have the label above the > value, so: "H2:J2 contains Brown and >90" is not right it should be > H2:H3 contains... > > Andreas > -- > Andreas J. Guelzow > Concordia University College of Alberta > > > > ------------------------------ > > _______________________________________________ > gnumeric-list mailing list > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list > > > End of gnumeric-list Digest, Vol 58, Issue 3 > ******************************************** >
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
