Home |
Search |
Today's Posts |
#1
|
|||
|
|||
would like help in Excess
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Assuming the first time goes in A1; in B1 enter =IF(A10,"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 wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you remove excess spaces from an Excel field? | Excel Discussion (Misc queries) | |||
ADD TIME IN EXCESS OF 24 HOURS | Excel Worksheet Functions | |||
Deleting excess rows and columns | New Users to Excel | |||
is there a way to set up a motthly budget plan thru excess?? or . | Excel Discussion (Misc queries) | |||
Husband died, office his name..added xp my name..now no excess to. | Excel Discussion (Misc queries) |