Concatenate text cell and formula cell result

  • Thread starter Thread starter GoinCrazy
  • Start date Start date
G

GoinCrazy

Can I do this:

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

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

I'm trying to result: Books (12345)
 
="Books "&COUNTA(G:G)
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
Oops.... forgot the ()

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

ROCK ON!,

Scott
 
Back
Top