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)
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)
=(your text) & (your formula output)
="Amount: " & COUNTA(A:A)should work.