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?
I am creating an Excel document where I place the letter X in a column and
want those X's to be added up and totaled at the bottom row. For example: B2 - X B3 - X B4 - X B5 - 3 As you can see, B5 has the result of 3 X's being input on B2:B4. So, how do I get the letter X to be recognized as a numerical 1 to be added? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get text to equal a number so I can sum a column?
You can count the number of times a "thing" occurs in a column with COUNTIF():
=COUNTIF(B2:B4,"X") in cell B5 -- Gary's Student "jimi" wrote: I am creating an Excel document where I place the letter X in a column and want those X's to be added up and totaled at the bottom row. For example: B2 - X B3 - X B4 - X B5 - 3 As you can see, B5 has the result of 3 X's being input on B2:B4. So, how do I get the letter X to be recognized as a numerical 1 to be added? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get text to equal a number so I can sum a column?
Try...
=COUNTIF(B2:B4,"X") Hope this helps! In article , jimi wrote: I am creating an Excel document where I place the letter X in a column and want those X's to be added up and totaled at the bottom row. For example: B2 - X B3 - X B4 - X B5 - 3 As you can see, B5 has the result of 3 X's being input on B2:B4. So, how do I get the letter X to be recognized as a numerical 1 to be added? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get text to equal a number so I can sum a column?
=COUNTA(B2:B4)
Vaya con Dios, Chuck, CABGx3 "jimi" wrote: I am creating an Excel document where I place the letter X in a column and want those X's to be added up and totaled at the bottom row. For example: B2 - X B3 - X B4 - X B5 - 3 As you can see, B5 has the result of 3 X's being input on B2:B4. So, how do I get the letter X to be recognized as a numerical 1 to be added? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get text to equal a number so I can sum a column?
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 |
#6
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 |