Prev: Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
Next: VBA: How to match two sets?
From: Kevin on 20 Apr 2010 23:06
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
From: Kevin on 21 Apr 2010 02:01
I figured it out, I used =COUNTIF($B$6:B33,"Y")+COUNTIF('2009'!B369:$B$370,"Y")

"Kevin" wrote:

> 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
 | 
Pages: 1
Prev: Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
Next: VBA: How to match two sets?