Hi everyone,
I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image).
The 2 sections are called Food and Non-Food.
The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other terms applied in this column are Awaiting Kick-off and Closed.
At the moment, there are no projects recorded for Food however I am getting a value. The expected value should be 0.
If anyone can advise the correct formula for this would be very much appreciated.
=COUNTIFS(Section:Section, "Food") + COUNTIFS(Stage:Stage, "Planning") + COUNTIFS(Stage:Stage, "Strategy Decision") + COUNTIFS(Stage:Stage, "Tender") + COUNTIFS(Stage:Stage, "Evaluation") + COUNTIFS(Stage:Stage, "Contract")
Thanks in advance,
Grace
