Trying to count values based on variables
Hi there - first question ever! Also - not great at using the right language so sorry if it's a bit confusing!
I am currently trying to use a formula to count if a certain condition is met in column a - and in column b - to count it. so for example
Column A (Role)
Column B (Off Work)
So the solution I'd like is from the information above - to find out how many people with the role Manager are currently off work?
I tried the following formulas and it keeps returning unparseable. Any suggestions?
=Countifs(Role:Role, "Manager", [Off Work:Off Work, "Yes"])
=COUNTIFS(Role:Role, “Manager”, Off Work:Off Work, "Yes")
The first half of the formula works and will count the number of managers in the column - but it doesn't like it after that!
Any help would be greatly appreciated.