Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count previous 30 cells two sheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count previous 30 cells two sheets
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
How do I make a 5th sheet to total cells from previous sheets in . | Excel Worksheet Functions | |||
count cells over multiple sheets | Excel Worksheet Functions |