Count previous 30 cells two sheets

[Kevin]

I have 5 sheets each one is 1 year. On each sheet in column J I am keeping a
total of how many times “Y†has been placed in column B for the previous 30
days. In J36 Jan 31 2010, I have =COUNTIF(B6:B35,"Y"). That works fine; it
counts the previous 30 days. Row 6 is the top of my page, so in J35 I would
like it to do the same thing but to take 29 previous days from the 2010
B6:B34 and B370 from 2009 sheet. Then for J34 the same thing, but it would
be for the previous 28 days (the first 28days of 2010) and then the last 2
days of 2009 (B369:B370). I have tried the same formula, but it only seems to
allow it to look at one sheet.

I am using office 2007

Thanks

Kevin

 

[Kevin]

I figured it out, I used =COUNTIF($B$6:B33,"Y")+COUNTIF('2009'!B369:$B$370,"Y")