Guys thank you very very much for this.
You both are saviors :)


-----Original Message-----
Hi again.

Range A1:10 has either "Full" or "Flex" as their contents.
they indicate whether a sales rep is full time or flex
time.

Say Column B has their name, or it may have Vacant
instead
of a name if no one has yet been hired for that territory.

I like to write a formula that looks in the range A1:a10
and B1:10 and gives me the count of how many are Flex
that
ARE NOT Vacant.

In other words give me a count of Flex that are not
vacant.

How do you do that?
Thanks everyone....
.