Hi,
I wonder if anyone might be able to give me a bit of advice. I have several
worksheets containing observation data from different days, all contained in
one workbook. I have assigned a numeric value to each state i.e. left=1,
right=2. I have four states and each time I collect data it goes on to a
dated (via the tab) worksheet. I want to total the number of each category
across the whole observation period. I have tried using the following
formula

=COUNTIFS('7 Dec'!F8:J15,1,'11 Jan'!F8:J15,1,'18 Jan'!F8:J14,1,'8
March'!F8:J14,1)

but it doesn't seem to work. I am using excel 2007 but I also need it to
work on excel 2003. it works if I only want one worksheet but I need to add
all occurrences of each state.

Any help would be gratefully appreciated.

Al the best,
Rob R