Concatenate text cell and formula cell result

[GoinCrazy]

Can I do this:

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

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

I'm trying to result: Books (12345)

 

[porter444]

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

ROCK ON!,

Scott

 

[porter444]

Oops.... forgot the ()

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

ROCK ON!,

Scott

 

[Teethless mama]

=CONCATENATE("Books (",COUNTA(G:G),")")

 

[Gary''s Student]

="Books (" & COUNTA(G:G) & ")"