would like help in Excess

G

Guest

In one of the columns would like to enter a time of completion, and in the
same row but different column would like the answer yes or no. yes if the
time is entered no if no time is entered would also like this collumne to add
up the yes and no's and give a total for each. Can anyone help me.
alan
 
R

Roger Govier

Hi

=COUNTIF(E2:E100,"=yes")

=COUNTIF(E2:E100,"=no")

change ranges to suit


Regards

Roger Govier
 
B

Bernard Liengme

Assuming the first time goes in A1; in B1 enter =IF(A1>0,"yes","no")
Now this will not differentiate between a time and a normal number
(problem?)
To add all the YES's use =COUNTIF(B1:B100,"yes")
You will get the same result using COUNTIF(A1:A100,">0")
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help with function and formulas 1
function help 1
bunch of "yes" or "no" entered in row, output 1 if a single yes 18
Clear excess formats in Excel 2007 3
Excel Count from last specific text 3
what formula for keeping balance of excess hours/minutes? 1
SUMIF Help 4
If formula with Yes or No 1

Top