| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count how many times x appears in a column?
Hi I have a table comprised of Y's and N's (which represent yes/no answers to questions and categories). I need to find the total number of Y's in each column. I thought this would be simple but I've hit a wall! I'd appreciate any help. Thanks a lot. Ian |
|
#2
|
|||
|
|||
|
Hi Ian,
=COUNTIF(A3:A13,"Y") -- Kind Regards, Niek Otten Microsoft MVP - Excel "Ian Roberts" wrote in message ... Hi I have a table comprised of Y's and N's (which represent yes/no answers to questions and categories). I need to find the total number of Y's in each column. I thought this would be simple but I've hit a wall! I'd appreciate any help. Thanks a lot. Ian |
|
#3
|
|||
|
|||
|
"Niek Otten" wrote in message ... Hi Ian, =COUNTIF(A3:A13,"Y") -- Kind Regards, Niek Otten Hi Niek Great thanks! You're a star. I^) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
| Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
| How do I count the amount of text in a column and then add them | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
