Try this:

=COUNTIF(A1:A5, "SOLD")&"/"&COUNTIF(B1:B5, "ITEM")

Biff

"exutable" wrote in
message ...

Hey I was working on something and I cant figure out how to put normal
text into a formula, for example:
COUNTIF(A1:A5, "SOLD")/COUNTIF(B1:B5, "ITEM")
I want it to come out like this: 3/5 but of course it divides the two
numbers.... Anybody know?


--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535403