Jim Rech, Ray A, and Domenic. A million thanks.

But Domenic, any chance explaining how your formula works. I was gobsmacked
when it worked first time!
For example, Why use indirect, date, 2005 and mmm. What if it wasn't a
timesheet and it was maybe a golf handicap. Would date, 2005 and mmm still be
used. Whilst this might be simple for you, to me I'm baffled.

Thanking everyone again for all your help
Big Rick


"Domenic" wrote:

Assuming that the sheet name for each month is abbreviated to three
letters, try...

=SUMPRODUCT(COUNTIF(INDIRECT(TEXT(DATE(2005,ROW(IN DIRECT("1:12")),1),"mmm
")&"!C:C"),"Sick"))

Hope this helps!

In article ,
"Big Rick" wrote:

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