Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding Columns in Excel
I have a row that has only Y's or N's. I want to total in two other
difference cells the number of Y's and the number of N's in that row. Any ideas? |
#2
|
|||
|
|||
DNA
Use a COUNTIF function for each like that below =COUNTIF(A1:G1,"Y") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "DNA" wrote in message lkaboutsoftware.com... I have a row that has only Y's or N's. I want to total in two other difference cells the number of Y's and the number of N's in that row. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
adding an horizontal scrollbar to columns | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
Perform functions on the result of adding two columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |