| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function IF or COUNTIF
Hi, I am trying to count the number of 'YES' in a column and the number of
'No' in another column. I cannot work out the function to do this! I would like to add a function at the bottom of the page somewhere which will automatically count as responses are entered - can anyone help with this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function IF or COUNTIF
Try this:
=COUNTIF(A1:A100,"Yes") =COUNTIF(B1:B100,"No") assuning you are looking for Yes's in column A and No's in column B. Adjust the ranges to suit. Hope this helps. Pete On Mar 20, 1:12 pm, JBee wrote: Hi, I am trying to count the number of 'YES' in a column and the number of 'No' in another column. I cannot work out the function to do this! I would like to add a function at the bottom of the page somewhere which will automatically count as responses are entered - can anyone help with this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function IF or COUNTIF
"JBee" wrote: Hi, I am trying to count the number of 'YES' in a column and the number of 'No' in another column. I cannot work out the function to do this! I would like to add a function at the bottom of the page somewhere which will automatically count as responses are entered - can anyone help with this? Thank you! Perfect. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function IF or COUNTIF
Thanks for feeding back - glad it worked for you.
Pete On Mar 20, 2:24 pm, JBee wrote: "JBee" wrote: Hi, I am trying to count the number of 'YES' in a column and the number of 'No' in another column. I cannot work out the function to do this! I would like to add a function at the bottom of the page somewhere which will automatically count as responses are entered - can anyone help with this? Thank you! Perfect. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| COUNTIF Function | Excel Discussion (Misc queries) | |||
| Countif function | Excel Discussion (Misc queries) | |||
Linear Mode
