I have a question about a google sheet formula?
=SUM(COUNTIF('Signed Case'!C:C,{"Barry","Maya"}))
It seems that Google Sheet can only count the total number of "Barry" but NOT BOTH "Barry" and "Maya", is there a way to fix this?
Greatly appreciated, thanks and have a nice day!