If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple worksheets
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 |
Thread Tools | |
Display Modes | |
|
|