Help on formula: count if with multiple criteria
I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula?
Here's the formula I used:
=COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation", Stage:Stage, "contract")
I only wanted to get the count in the highlighted cells in Stage column that has these 5 stages: