Re: Array Function
- From: Mangus Pyke <manguspyke@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Jul 2005 10:55:04 -0400
On 18 Jul 2005 07:09:10 -0700, "Egon" <jhalljr@xxxxxxxxx> wrote:
>Maybe I didn't explain myself properly.
>
>I have a list of positions in the "A" Column and a list of companies in
>the "B" column. I need to get the number of positions in the "A" column
>who's company is equal to a certain company in the B column.
>
>CountIF seems to only count within a certain column.
>
>Does that explain it better?
>
>Thanks
>J.
=COUNT(IF(A2:A100=[insert criteria],IF(B2:B100=[insert
criteria],1,0),0)
And confirm with Ctrl+Shift+Enter
MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner
.
- References:
- Array Function
- From: Egon
- Re: Array Function
- From: Bob Phillips
- Re: Array Function
- From: Egon
- Array Function
- Prev by Date: Complicated lookup function
- Next by Date: Re: Array Function
- Previous by thread: Re: Array Function
- Next by thread: Re: Array Function
- Index(es):
Relevant Pages
|
