software

Hey I was working on something and I cant figure out how to put normal
text into a formula, for example:
COUNTIF(A1:A5, quot;SOLDquot;)/COUNTIF(B1:B5, quot;ITEMquot;)
I want it to come out like this: 3/5 but of course it divides the two
numbers.... Anybody know?--
exutable
------------------------------------------------------------------------
exutable's Profile: www.excelforum.com/member.php...oamp;userid=28665
View this thread: www.excelforum.com/showthread...hreadid=535403Try this:

=COUNTIF(A1:A5, quot;SOLDquot;)amp;quot;/quot;amp;COUNTIF(B1:B5, quot;ITEMquot;)

Biff

quot;exutablequot; gt; wrote in
message ...
gt;
gt; Hey I was working on something and I cant figure out how to put normal
gt; text into a formula, for example:
gt; COUNTIF(A1:A5, quot;SOLDquot;)/COUNTIF(B1:B5, quot;ITEMquot;)
gt; I want it to come out like this: 3/5 but of course it divides the two
gt; numbers.... Anybody know?
gt;
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535403
gt;

Thanks man worked great!--
exutable
------------------------------------------------------------------------
exutable's Profile: www.excelforum.com/member.php...oamp;userid=28665
View this thread: www.excelforum.com/showthread...hreadid=535403You're welcome. Thanks for the feedback!

Biff

quot;exutablequot; gt; wrote in
message ...
gt;
gt; Thanks man worked great!
gt;
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535403
gt;
Hi

The another option is to format the cell as Fraction - the the result
remains a number.--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;exutablequot; gt; wrote in
message ...
gt;
gt; Hey I was working on something and I cant figure out how to put normal
gt; text into a formula, for example:
gt; COUNTIF(A1:A5, quot;SOLDquot;)/COUNTIF(B1:B5, quot;ITEMquot;)
gt; I want it to come out like this: 3/5 but of course it divides the two
gt; numbers.... Anybody know?
gt;
gt;
gt; --
gt; exutable
gt; ------------------------------------------------------------------------
gt; exutable's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28665
gt; View this thread: www.excelforum.com/showthread...hreadid=535403
gt;