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?

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?

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.

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.