Normal Text in Formula

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?

Try this:

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

Biff

"exutable" <exutable.26r0io_1145848205.9538@excelforum-nospam.com> wrote in
message news:exutable.26r0io_1145848205.9538@excelforum-nospam.com...
>
> 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
>

Thanks man worked great!

You're welcome. Thanks for the feedback!

Biff

"exutable" <exutable.26r1wm_1145850001.8931@excelforum-nospam.com> wrote in
message news:exutable.26r1wm_1145850001.8931@excelforum-nospam.com...
>
> Thanks man worked great!
>
>
> --
> exutable
> ------------------------------------------------------------------------
> exutable's Profile:
> http://www.excelforum.com/member.php...o&userid=28665
> View this thread: http://www.excelforum.com/showthread...hreadid=535403
>

Hi

The another option is to format the cell as Fraction - the the result
remains a number.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"exutable" <exutable.26r0io_1145848205.9538@excelforum-nospam.com> wrote in
message news:exutable.26r0io_1145848205.9538@excelforum-nospam.com...
>
> 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
>