I have 1000 sports games, each with about 500 rows of data.
I need to tabulate the data for each game.
I have inserted two empty rows at the bottom of each game.
I need a macro (I think) which allows me to do a countif function and then inserts the result at the bottom of each game. The range for the countif function needs to be one game i.e. from one empty row to another. There are also three criteria which need to be satisfied for it to be counted.
For example, I would like:
To count all the times column C has "Manchester United" and column D has "shot" and column E has "missed". But count this for each game (i.e. between empty rows).
Thanks for any help
David
I need to tabulate the data for each game.
I have inserted two empty rows at the bottom of each game.
I need a macro (I think) which allows me to do a countif function and then inserts the result at the bottom of each game. The range for the countif function needs to be one game i.e. from one empty row to another. There are also three criteria which need to be satisfied for it to be counted.
For example, I would like:
To count all the times column C has "Manchester United" and column D has "shot" and column E has "missed". But count this for each game (i.e. between empty rows).
Thanks for any help
David
