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.

Oops.. make that "SUM" instead of "COUNT" in my answer.

Sorry, waking.

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner