Re: Count rows based on multiple variables
From: Myrna Larson (anonymous_at_discussions.microsoft.com)
Date: 10/27/04
- Next message: Chris Shipley: "Re: Macro Assistance with Incrementing Formula"
- Previous message: Mcasteel: "Re: Possible to move data to a specific cell?"
- In reply to: Murph: "Count rows based on multiple variables"
- Next in thread: Murph: "Re: Count rows based on multiple variables"
- Reply: Murph: "Re: Count rows based on multiple variables"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 21:50:54 -0500
You say "the same". Do you intend to specify what that name and text is, or is
the formula supposed to just count duplicates based on columns B and C where A
is between 1 and 10?
On Tue, 26 Oct 2004 17:41:01 -0700, "Murph" <Murph@discussions.microsoft.com>
wrote:
>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.
- Next message: Chris Shipley: "Re: Macro Assistance with Incrementing Formula"
- Previous message: Mcasteel: "Re: Possible to move data to a specific cell?"
- In reply to: Murph: "Count rows based on multiple variables"
- Next in thread: Murph: "Re: Count rows based on multiple variables"
- Reply: Murph: "Re: Count rows based on multiple variables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
