rama4672
05-14-2005, 10:37 AM
I need to input a formula that counts how many times a certain number occures in a column.
The formula that i have got at the moment is: =COUNTIF(E:E,10) That works fine but there are some cells that i do not want it to count, there are people who are on holiday and sick i do not want it to count those occurances, i have tried the following but what this does is it just counts the occurances of hol not how many people who are on 10 hour shifts that are on hol
=COUNTIF(E:E,10)-COUNTIF(F:F,"hol")-COUNTIF(F:F,"sick")
I need it to count just the 10 and i also have another formula that does the same but for 8
Regards
Ian
The formula that i have got at the moment is: =COUNTIF(E:E,10) That works fine but there are some cells that i do not want it to count, there are people who are on holiday and sick i do not want it to count those occurances, i have tried the following but what this does is it just counts the occurances of hol not how many people who are on 10 hour shifts that are on hol
=COUNTIF(E:E,10)-COUNTIF(F:F,"hol")-COUNTIF(F:F,"sick")
I need it to count just the 10 and i also have another formula that does the same but for 8
Regards
Ian