N
NetMaster
I have a monster spreadsheet. It collects data from IT Problems in
infrastructure.
I need to count the number of problems that occurred in Jan 2009.
Here is my current formula.
Column AQ has the Month opened. (1 thru 12)
D$5 has the month in question. (jan-09)(Feb-08), etc...
=COUNTIF('In Progress'!$AQ$3:$AQ$4079,MONTH(D$5))+COUNTIF('Closed
Problems'!$AQ$3:$AQ$3996,MONTH(D$5))
It has worked fine until 2009. Now I have Problems that span both 2008 and
2009. So the current formula still counts 2008. To show the New problems for
Jan-09 I have to test for 2009, so it ignores 2008 problems.
Column AR has the Year opened. (2008 thru 2009, etc...)
When I try the formula below I get zero.
=COUNTIF('In Progress'!$AQ$3:$AQ$4079,MONTH(D$5))+COUNTIF('In
Progress'!$AR$3:$AR$4079,YEAR(D$5))+COUNTIF('Closed
Problems'!$AQ$3:$AQ$3996,MONTH(D$5))+COUNTIF('Closed
Problems'!$AR$3:$AR$3996,YEAR(D$5))
Can I doo something like this?
=IF(AND(AJ9:AJ14="1",AK9:AK14="2009"),COUNT(AI9:AI14),"No Value")
Thanks in advanced.
Bob
infrastructure.
I need to count the number of problems that occurred in Jan 2009.
Here is my current formula.
Column AQ has the Month opened. (1 thru 12)
D$5 has the month in question. (jan-09)(Feb-08), etc...
=COUNTIF('In Progress'!$AQ$3:$AQ$4079,MONTH(D$5))+COUNTIF('Closed
Problems'!$AQ$3:$AQ$3996,MONTH(D$5))
It has worked fine until 2009. Now I have Problems that span both 2008 and
2009. So the current formula still counts 2008. To show the New problems for
Jan-09 I have to test for 2009, so it ignores 2008 problems.
Column AR has the Year opened. (2008 thru 2009, etc...)
When I try the formula below I get zero.
=COUNTIF('In Progress'!$AQ$3:$AQ$4079,MONTH(D$5))+COUNTIF('In
Progress'!$AR$3:$AR$4079,YEAR(D$5))+COUNTIF('Closed
Problems'!$AQ$3:$AQ$3996,MONTH(D$5))+COUNTIF('Closed
Problems'!$AR$3:$AR$3996,YEAR(D$5))
Can I doo something like this?
=IF(AND(AJ9:AJ14="1",AK9:AK14="2009"),COUNT(AI9:AI14),"No Value")
Thanks in advanced.
Bob