counting based on 2 conditions
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....
|