I created formulas and saved the file as a template. I then imported data onto another sheet in that template and saved it as a file.
A simple COUNT function refuses to count. The function is
=COUNT(hands!$A$3:$A$64995)
I deleted the function and retyped it in - answer 0
I deleted the function and used the function wizard and selected the referenced cells on the sheet - answer 0
I went back into the file that I created the template from and changed the number of entries on the sheet named "hands" - and the formula returned the correct, lower number.
I have no idea why this formula isn't working. Other much more complex formulas appear to be working correctly. Please help.
A simple COUNT function refuses to count. The function is
=COUNT(hands!$A$3:$A$64995)
I deleted the function and retyped it in - answer 0
I deleted the function and used the function wizard and selected the referenced cells on the sheet - answer 0
I went back into the file that I created the template from and changed the number of entries on the sheet named "hands" - and the formula returned the correct, lower number.
I have no idea why this formula isn't working. Other much more complex formulas appear to be working correctly. Please help.