"Books Added in October 2020 " & "counta(A3:A)"
This is not working.
Can someone help me?

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. – marikamitsos Oct 11 at 1:05
  • Please include a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Oct 11 at 1:21

You need to correct the syntax in your formula.

It should be

="Books Added in October 2020 " & counta(A3:A)

That is: = "some text here" & myformula
Or maybe: = "some text here" & myformula & "more text"
Or even: = "some text here" & myformula & "more text" & another formula

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.