I am trying to use a formula to count the number of rows in a worksheet including blank cells.
If I use
=COUNTA(A:A)
then it returns the count of cells which contain a value
If I use
=COUNTIF(A:A,"")
it will count the blank cells in column A within the current used range in Excel 2000
using the same COUNTIF formula returns a count of the blank cells in the entire column in Excel 2007.
Therefore in Excel 2000 I can use
=COUNTA(A:A) + COUNTIF(A:A,"") and get the correct count
In Excel 2007 the same formula returns a count of all the cells.
Any idea of a fomula which will work in Excel 2007 that will return the empty cells in the used range?
Even better would be a formula which will return the same count (used and empty cells) in both 2000 and 2007.
TIA
Bookmarks