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
|