Count of Worksheet rows and recording this count

[mikerobe]

Hi,
I have data in a Worksheet (Sheet1) in Columns A and B, the number of
rows of data is variable. The first and last row of data is a header
and footer. I need to count the rows in between the header and footer
(not counting the header and footer rows) and place this count (same
number) in the header row and footer row in Coulum C. For example the
count in the header row would be placed in cell C1 and the count in
the footer is in cell CX (x being a variable)

I hope this is clear

Thanks for any help
Mike

 

[JMay]

I'de put in cell B1 =COUNTA(A:A)-2

What else is in Column B (B2:B99) say?

If nothing then enter in B2 and copy down

=IF(A2="Footer",B$1,"")

Maybe..??

 

[mikerobe]

I'de put in cell B1 =COUNTA(A:A)-2

What else is in Column B (B2:B99) say?

If nothing then enter in B2 and copy down

=IF(A2="Footer",B$1,"")

Maybe..??








- Show quoted text -

Thanks for the suggestion JMay
But there is awways data in Column B from B1 to B99 (for example) but
as I say this is variable in that the dat could end in B60.

Thanks
Mike