| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Autocomplete based on a different worksheet. | Excel Discussion (Misc queries) | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Threaded Mode
