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

P

PCLIVE

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

Mike H

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

PCLIVE said:
You may need to actually elaborate what you're trying to do. Somehow the
subject line just doesn't say it.
Click to expand...
[/QUOTE]
 
T

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.

PCLIVE said:
You may need to actually elaborate what you're trying to do. Somehow the
subject line just doesn't say it.
Click to expand...
[/QUOTE]
 
S

Sandy Mann

Try:

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

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk


trussdesigns said:
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.
Click to expand...
[/QUOTE]
 
P

Peo Sjoblom

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

change the cell range to fit your requirements

--


Regards,


Peo Sjoblom

trussdesigns said:
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.
Click to expand...
[/QUOTE]
 
P

Pete_UK

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

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

Hope this helps.

Pete
 
Top