Stresbringer
Board Regular
- Joined
- Mar 16, 2006
- Messages
- 84
Hi Guys
I have a spreadsheet which contains a Summary sheet & 12 Monthly data sheets in each sheet column H is a named range labeled Jan - Dec etc
On the Summary sheet I have a formulas which count The critera which appear in these ranges
Ie CountIF(JAN,$A40)
CountIF(FEB,A40)....
What i need to do is have one annual data sheet rather than 12 and i need a formula which counts the critera as above but only counts it when it falls within a certain date range ..ie Jan Feb mar etc
I plan to have annual sheets which will be labled 2008, 2009 etc
Ie
Count if x and is between 01/01/08 - 31/01/08
Count if x and is between 01/02/08 - 28/02/08
Can anyone help?
I have a spreadsheet which contains a Summary sheet & 12 Monthly data sheets in each sheet column H is a named range labeled Jan - Dec etc
On the Summary sheet I have a formulas which count The critera which appear in these ranges
Ie CountIF(JAN,$A40)
CountIF(FEB,A40)....
What i need to do is have one annual data sheet rather than 12 and i need a formula which counts the critera as above but only counts it when it falls within a certain date range ..ie Jan Feb mar etc
I plan to have annual sheets which will be labled 2008, 2009 etc
Ie
Count if x and is between 01/01/08 - 31/01/08
Count if x and is between 01/02/08 - 28/02/08
Can anyone help?