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

  • Thread starter Thread starter trussdesigns
  • Start date Start date
You may need to actually elaborate what you're trying to do. Somehow the
subject line just doesn't say it.
 
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]
 
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]
 
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


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]
 
="("&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]
 
Assuming your heading is in A1, modify it to this:

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

Hope this helps.

Pete
 
Back
Top