Hi All,
I have a spreadsheet for football stats and need help with the following:
The formula below has three criteria - How many goals has 'Fernandes' scored in the 'PL' in '20/21'
In the second picture you can see that Fernandes is listed more than one time in one row but the CCOUNTIF formula only counts first instance.
What is the formula to count all instances of keywords in one row in a range?
I have a spreadsheet for football stats and need help with the following:
The formula below has three criteria - How many goals has 'Fernandes' scored in the 'PL' in '20/21'
In the second picture you can see that Fernandes is listed more than one time in one row but the CCOUNTIF formula only counts first instance.
What is the formula to count all instances of keywords in one row in a range?