Formula to calculate number of print pages requires

I am looking for a formula that will calculate the number of pages it would take to print out all the data on a search page. Each printed page has 24 records. The records start on B11 and goes down. So basically the formula should find the number of rows containing records (by searching for the last row after 11 with data in B), and then divide the number of rows by 24 (number of records per page). The answer should be a whole number, and then display the text 'Pages' after it.

Thanks.

Try this:

=ROUNDUP((COUNTA(B:B)-COUNTA(B1:B10))/24,0)

Assumes your records are contiguous, i.e. no blank rows.

Hope this helps.

Pete

It didnt quite seem to work. It came back with 63, and in the current state it should be 12. I have attached my worksheet.
The formula is on the Search sheet in A10. As search criteria is entered into the search cells (E1:E6) the page count should be changing (since the number of records below is also changing). But it seems to stay at 63.
Also i would like the cell to display the text Pages after the number.

Ah yes, you have copied a formula in column B down to row 1500, so COUNTA will be counting those as well. Use COUNT instead, as FDibbins suggests.

Pete