Count rows based on multiple variables

From: Murph (Murph_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Tue, 26 Oct 2004 17:41:01 -0700

I'm having trouble figuring out a way to count specific rows in a database I
have, using multiple variables. For example. I have column A, B, and C. In
column "A" are number values from 1-10. In Column "B" are peoples names, and
in Column "C" are other text values. I want to figure out a way to count all
the rows that have the numbers 1-3 in column "A", the same name in column
"B", and the same text value in column "C". I've tried using multiple
variations of the COUNT, DCOUNT, SUM, and DSUM functions but have had no
luck. Any help would be appreciated. 

-- 
Brendan

Relevant Pages

  • Re: Count rows based on multiple variables
    ... Don Pistulka ... > I'm having trouble figuring out a way to count specific rows in a database ... > have, using multiple variables. ...
    (microsoft.public.excel.programming)
  • Count rows based on multiple criteria
    ... I'm having trouble figuring out a way to count specific rows in a database I ... have, using multiple variables. ... luck. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: "On the Fly" - another way to word this?
    ... single or multiple variables in the contact data profile in which ... Creating a call list directly from a database just as one might ... told to do without making value judgments about what they do. ...
    (alt.usage.english)
  • RE: Count rows based on multiple criteria
    ... "Murph" wrote: ... > have, using multiple variables. ... > luck. ...
    (microsoft.public.excel.worksheet.functions)