Sunshine8790
Board Regular
- Joined
- Jun 1, 2021
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
Maybe I'm just using the wrong formula, but my current formula is:
This is counting the amount of cells on another sheet that contain a "-" symbol in column V, if Column R contains an "S".
This works - however, I also need the formula to not include counts if Column Q contains "Inactive".
How do I do this?
Excel Formula:
=COUNTIFS('Main Sheet'!V:V,"-",'Main Sheet'!R:R,"S")
This works - however, I also need the formula to not include counts if Column Q contains "Inactive".
How do I do this?