Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it always shows '0'. What am i doing wrong?
The formula I'm using is:
=COUNTIFS([Overall Status]:[Overall Status], "Selected", [Overall Status]:[Overall Status], "WIP", [Overall Status]:[Overall Status], "Pending Verification")