The spreadsheet that I am working with is for my football team. The help that I need is with the COUNT formula I think. In
column Q I have all the cells that contain YES counted in cell Q49. I want a formula that will count the amount of times that
a team has played at home this season. Whether a team has played at home or away is signalled by a H or an A in column B.
When I use this formula
it counts all the home games that a team will play this season, what I need is for all the home games that they have
currently played, so that I can express it as a percentage of the 4 'YES''s in column Q.
Any help is greatly appreciated.
I have attached my spreadsheet for people to look at.