Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have 2 columns in Excel "yes" and "no" can I add them up?
I replaced the yes with a 1 and the no's with a 2. Is it possible to keep the
yes and no's and add up the columnx? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have 2 columns in Excel "yes" and "no" can I add them up?
What do you want to add up? Do you want to get the number of "Yes" and the
number of "No"? If so, look in Help for CountIf. HTH Otto "SSharp" wrote in message ... I replaced the yes with a 1 and the no's with a 2. Is it possible to keep the yes and no's and add up the columnx? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have 2 columns in Excel "yes" and "no" can I add them up?
Hi,
=COUNTIF(A1:A100,"Yes")+COUNTIF(A1:A100,"No")*2 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SSharp" wrote: I replaced the yes with a 1 and the no's with a 2. Is it possible to keep the yes and no's and add up the columnx? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |