Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF Help
My file has 13 sheets in it. One called Holidays, the others Apr to Mar.
In Holidays, I want a simple number of how many sick days taken. With help from a previous post, I have changed my formula of =COUNTIF(C5:C11,"Sick")+COUNTIF(C13:C19,"Sick")etc (5 blocks per sheet) to =COUNTIF(C:C),"Sick") which will count the whole column, although this will obviously only work if it is on the individual sheet itself. Please can you help me change it to the total number in of sick days taken in the whole 12 months. This is to be put in the Holidays sheet. Thanking you in anticipation -- Big Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF help | Excel Worksheet Functions | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |