=COUNTIF(N3:N10016, "YES")&" Sold"
=COUNTIF(N3:N10016, "NO")&" In Stock"

Vaya con Dios,
Chuck, CABGx3


"Robbie in Houston" wrote in message
...
I am curious if there is a way to add text to the result of a formula.
For
instance, I would like the formulas

O1: =COUNTIF(N3:N10016, "YES")
P1: =COUNTIF(N3:N10016, "NO")

to appear as:

O1: 1027 Sold
P1: 8987 In Stock

without having to type the text in a different cell.

Thanks in advance,
Robbie