Forum Discussion
CountIf multiple variables
Hello everyone, I'm a coach of a first year sporting team. I wanna be able to quickly see how often everyone is training and what kind of training it is (fixed amount of options). Using the coun...
Hi,
COUNTIFS function can handle multiple criterion.
e.g you can use this formula to get "How often Boat" for Person A:
=COUNTIFS(C3:C11, "Boat",D3:D11,"*A*")
COUNTIFS function can handle multiple criterion.
e.g you can use this formula to get "How often Boat" for Person A:
=COUNTIFS(C3:C11, "Boat",D3:D11,"*A*")