Counting Rows

[Craneo]

Hi,

Having thicky moment but what is the formula to count the number of rows containing non-blank cells in a preset range of rows?

Thanks in advance

 

[PaddyD]

=COUNTA(A1:A10)

paddy

 

[Craneo]

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?

 

[Aladin Akyurek]

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?

=COUNTIF(Sheet1!A4:A150,"<>")

 

[Craneo]

Thanks very much for the input Aladin.

I don't think I've explained it too well. I have worksheet 26 columsn wide with 151 rows. I want my formula to count the rows that contain contain data ,minus header rows, but not the individual cells themselves