mearmortal
Programmer
I use this formula: -
=COUNTIF('Games'!C1:C46,"Europe ")
But the end cell number changes based upon it being the last empty cell, calculated from this formula: -
=MATCH("Y",'Games'!F:F,0)-1
This formula reports the row number in column F with a Y in it and returns the value -1. Hence the last empty cell.
What I want to do is substitute the value generated from the second formula with the value in the first that reports 46 above.
I can't see how to do it, can I have someones assistance please.
=COUNTIF('Games'!C1:C46,"Europe ")
But the end cell number changes based upon it being the last empty cell, calculated from this formula: -
=MATCH("Y",'Games'!F:F,0)-1
This formula reports the row number in column F with a Y in it and returns the value -1. Hence the last empty cell.
What I want to do is substitute the value generated from the second formula with the value in the first that reports 46 above.
I can't see how to do it, can I have someones assistance please.