Re: Count rows based on multiple variables
From: Don (dummy_at_here.com)
Date: 10/27/04
- Next message: Dave Peterson: "Re: truncation problem"
- Previous message: Chris Shipley: "Re: Possible to move data to a specific cell?"
- In reply to: Murph: "Count rows based on multiple variables"
- Next in thread: Myrna Larson: "Re: Count rows based on multiple variables"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 19:23:36 -0700
Murph
Try:
=SUMPRODUCT((B1:B10="Jones")*(C1:C10="Feb")*(A1:A10>=1)*(A1:A10<=3))
Don Pistulka
"Murph" <Murph@discussions.microsoft.com> wrote in message
news:69EDAA1A-CB94-41BD-B55F-2CB4A120B268@microsoft.com...
> 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
- Next message: Dave Peterson: "Re: truncation problem"
- Previous message: Chris Shipley: "Re: Possible to move data to a specific cell?"
- In reply to: Murph: "Count rows based on multiple variables"
- Next in thread: Myrna Larson: "Re: Count rows based on multiple variables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
