Can countifs work with an "OR" in it? Seperating in the below formula the BO
& AY criteria into 2 countifs works but I would like to do it with just 1
countifs if possible.
Doesn't
work:=COUNTIFS(AMC!$C$2:$C$1796,OR($BO$67,$AY$67),AMC!$R$2:$R$1796,"="&$A85,AMC!$E$2:$E$1796,"="&CT$67)
Does
work:=COUNTIFS(AMC!$C$2:$C$1796,$BO$67,AMC!$R$2:$R$1796,"="&$A85,AMC!$E$2:$E$1796,"="&CT$67)+COUNTIFS(AMC!$C$2:$C$1796,$AY$67,AMC!$R$2:$R$1796,"="&$A85,AMC!$E$2:$E$1796,"="&CT$67)