Adding Cells with Words

gymwrecker · May 1st, 2002, 07:55 PM

I have cells that contain the following words: Failed; Passed; Not Tested. How could I segregate them and add at the end of the spreadsheet? In other words, how could I make excel identify words as numbers and at the end, Total, convert to a number, for example

Number Failed:
Number Passed:
Number Not Tested:

Thanks!

Qroozn · May 1st, 2002, 08:13 PM

use the countif function at the bottom of your spreadsheet
=COUNTIF(yourrange,"failed")

likewise do a formula for your other "words"

[ This Message was edited by: Qroozn on 2002-05-01 19:15 ]

gymwrecker · May 4th, 2002, 07:33 PM

Thank You very much! It did work immediately!!!

Nimrod · May 4th, 2002, 07:40 PM

Another nice Solution is to use the built in command on your tool bar to expand an collapse the data .
IE: On the Tool bar select "Data" and then select "SubTotals"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 07:55 PM	#1
gymwrecker Board Regular Join Date: Apr 2002 Location: Fort Knox, KY Posts: 249	I have cells that contain the following words: Failed; Passed; Not Tested. How could I segregate them and add at the end of the spreadsheet? In other words, how could I make excel identify words as numbers and at the end, Total, convert to a number, for example Number Failed: Number Passed: Number Not Tested: Thanks!

May 1st, 2002, 08:13 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	use the countif function at the bottom of your spreadsheet =COUNTIF(yourrange,"failed") likewise do a formula for your other "words" [ This Message was edited by: Qroozn on 2002-05-01 19:15 ]

May 4th, 2002, 07:33 PM	#3
gymwrecker Board Regular Join Date: Apr 2002 Location: Fort Knox, KY Posts: 249	Thank You very much! It did work immediately!!!

May 4th, 2002, 07:40 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Another nice Solution is to use the built in command on your tool bar to expand an collapse the data . IE: On the Tool bar select "Data" and then select "SubTotals"