You are either going to have to have a COUNTIF on each sheet and then sum
those cells on the summary sheet or use a formula like this:

=COUNTIF(Sheet1!C:C,"a")+COUNTIF(Sheet2!C:C,"a")+. ...

--
Jim
"Big Rick" wrote in message
...
| 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