would like help in Excess

[fomula problems]

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

[Roger Govier]

Hi

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

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

change ranges to suit


Regards

Roger Govier


fomula problems wrote:
> 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

[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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"fomula problems" <fomula problems@discussions.microsoft.com> wrote in
message news:12FF32A1-9FC7-40A9-915A-E8A4DBC768B8@microsoft.com...
> 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