| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get text to equal a number so I can sum a column?
=COUNTIF(Sheet2!C:C,"on")
=COUNTIF(Sheet2!C:C,"off") ="On = "&COUNTIF(Sheet2!C:C,"on")&CHAR(10)&"Off = "&COUNTIF(Sheet2!C:C,"off") formatted for WrapText. Vaya con Dios, Chuck, CABGx3 "respinosa" wrote in message ... I have a similar problem. Trying to get a word(s) in a column on Sheet2 to total in a cell on Sheet1. So down Column C, how many times the word "Off" or "On" appears to total on Sheet1 under their perspective rows of "Off" and "On". -- respinosa ------------------------------------------------------------------------ respinosa's Profile: http://www.excelforum.com/member.php...o&userid=35231 View this thread: http://www.excelforum.com/showthread...hreadid=549633 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| The last column in my word document contains both text and number | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Hybrid Mode
