Google sheets query with text -


this stupid question can't seem find answer anywhere. i'm trying use simple counta query want text appear "amount = "=counta(b16:b25)

=(your text) & (your formula output)

="amount: " & counta(a:a)

should work.


Comments