Google sheets query with text

619 Views Asked by At

This is probably a very stupid question but I can't seem to find an answer for it anywhere. I'm trying to use a simple COUNTA query but I also want text to appear so something like this "Amount = "=COUNTA(B16:B25)

1

There are 1 best solutions below

0
On

=(your text) & (your formula output)

="Amount: " & COUNTA(A:A)

should work.