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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed):

> 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

On Mar 21, 1:17 am, "JMay" <j...@cox.net> 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" <eid...@gmail.com> wrote in message
>
> news:(E-Mail Removed):
>
>
>
> > 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