Is this possible: =counta(a1:a30) behind "text" same cell?

[trussdesigns]

 

[PCLIVE]

You may need to actually elaborate what you're trying to do. Somehow the
subject line just doesn't say it.

 

[Mike H]

You should also post in the body of the message or some of us can't reply

You may need to actually elaborate what you're trying to do. Somehow the
subject line just doesn't say it.

[/QUOTE]

 

[trussdesigns]

i have a list of items in a column. i have a column heading at the top. i'd
like to have a count beside the column heading in perithesis letting me know
how many items are below that column.

You may need to actually elaborate what you're trying to do. Somehow the
subject line just doesn't say it.

[/QUOTE]

 

[Sandy Mann]

Try:

="My Header ("&COUNTA(G2:G100)&")"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

i have a list of items in a column. i have a column heading at the top. i'd
like to have a count beside the column heading in perithesis letting me
know
how many items are below that column.

[/QUOTE]

 

[Peo Sjoblom]

="("&COUNTA(A2:A50000)&")"

change the cell range to fit your requirements

--


Regards,


Peo Sjoblom

i have a list of items in a column. i have a column heading at the top. i'd
like to have a count beside the column heading in perithesis letting me
know
how many items are below that column.

[/QUOTE]

 

[Pete_UK]

Assuming your heading is in A1, modify it to this:

="your_heading ("&COUNTA(A2:A65536)&")"

Hope this helps.

Pete