On 2002-11-03 18:58, Craneo wrote:
Thanks for the help Paddy. Though that appears to count the non-blank cells within the range .. i wanted my formula to count the number of rows that contain the non-blank cells in a pre-determined selection of rows.
Here's the formula i was using (which was returning an incorrect answer)
=ROWS(COUNTA(Sheet1!A4:A150))
Where have I gone wrong?