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?


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

Normal Text in Formula
 

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

Normal Text in Formula
 

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

Normal Text in Formula
 

You're welcome. Thanks for the feedback!

Biff

"exutable" wrote in
message ...

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

Normal Text in Formula
 

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<attarkon.ee )



"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