Re: Database Functions

[Mario Rappi <mrappi gmail com>]

Have you tried =DCOUNTA(address of datablock,H1:J1,H1:J2)

On Wed, Feb 11, 2009 at 6:00 AM, <gnumeric-list-request gnome org> wrote:

Send gnumeric-list mailing list submissions to
       gnumeric-list gnome org

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
       gnumeric-list-request gnome org

You can reach the person managing the list at
       gnumeric-list-owner gnome org

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" <cvandy26 gmail com>
Subject: Database Functions
To: <gnumeric-list gnome org>
Message-ID: <49919ABE 00000F 03020 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 <aguelzow math concordia ab ca>
Subject: Re: Database Functions
To: gnumeric-list gnome org
Message-ID: <1234281762 20038 8 camel 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
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


End of gnumeric-list Digest, Vol 58, Issue 3
********************************************