COUNTIF Problem for several sheets

[Greenturtle]

Hey Guys,

I'm trying to create a ROTA using excel. I want to use the COUNTIF function to tell me how many days in a month an employee has off.

Under the respective day, a number 2 indicates the employee has a day off.

For a month, there are four pages (one per week) so I'm trying to reference different cells on different pages to find out how many 2's there are.

On my 'summary page' (where this information is displayed) to access data from one page is easy:

=COUNTIF('31-5-10'!E11:P11,"2")

but when I want the data from the remaining three pages:

'7-6-10' C11:P11
'14-6-10' C11:P11
'21-6-10' C11:P11
'28-6-10' C11:G11

I just get errors when I try and create the formula. Could anyone point me in the right direction, or show me how to merge the 5 pages worth of references into one formula?

Thanks!

Sam

[NBVC]

You can add separate COUNTIF's (one for each together)..

e.g.. =COUNTIF()+COUNTIF()+, etc...