Count of Worksheet rows and recording this count
 

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

Count of Worksheet rows and recording this count
 

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" wrote in message
oups.com:

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

Count of Worksheet rows and recording this count
 

On Mar 21, 1:17 am, "JMay" wrote:
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" wrote in message

oups.com:



Hi,
I have data in aWorksheet(Sheet1) in Columns A and B, the number of
rowsof data is variable. The first and last row of data is a header
and footer. I need tocounttherowsin between the header and footer
(not counting the header and footerrows) and place thiscount(same
number) in the header row and footer row in Coulum C. For example the
countin the header row would be placed in cell C1 and thecountin
the footer is in cell CX (x being a variable)

I hope this is clear

Thanks for any help
Mike- Hide quoted text -

- 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