Will functions work if I want a other text in the cell as well?

[SGTNicholson]

Hello and thanks in advance for the help

Down to business I would like to put a countif function in a cell and want it to display the number then what its counting in the same cell IE [13 Cookies] instead of [13][cookies]

[Tony Valko]

Yeah, you can do that.

Something like this:

=COUNTIF(A:A,"Cookies")&" Cookies"

[ragulduy]

you could do:
=countif(A:A,"=Cookies") & " Cookies"
?

[Pete_UK]

Your formula will be something like:

=COUNTIF(A:A,"cookies") & " cookies"

Hope this helps.

Pete

[Pepe Le Mokko]

Do you mean a custom format like 0 "cookies". ( Will always show "cookies" though)

[Tony Valko]

And, to make it grammatically correct...

1 Cookies just doesn't sound or look right.

This will eliminate that problem:

=COUNTIF(A:A,"Cookies")&" Cookie"&IF(COUNTIF(A:A,"Cookies")<>1,"s","")

[SGTNicholson]

Awsome that works great thanks everyone

[Tony Valko]

You're welcome. We appreciate the feedback!