Concatenate text cell and formula cell result

G

GoinCrazy

Can I do this:

=CONCATENATE("Books (",=counta(G:G),x,")")

?????????????????????

I'm trying to result: Books (12345)
 
P

porter444

="Books "&COUNTA(G:G)
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
P

porter444

Oops.... forgot the ()

="Books ("&COUNTA(G:G)&")"
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
Top