Thread: Array Function
View Single Post
  #5   Report Post  
Mangus Pyke
 
Posts: n/a
Default

On 18 Jul 2005 07:09:10 -0700, "Egon" 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