Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Problem
I know there is a simple solution to my problem. The following is my formula:
=COUNT(IF((TEXT(IndexData!$G$5:$G$23309,"yyyymm")= "200501")*(IndexData!$A$5:$A$23309="AUT"),AND(Inde xData!$I$5:$I$23309<=3,""),IndexData!$I$5:$I$23309 )) The formula is not bringing back to the number of "AUT" less than or equal to 3, if it were the number would be Zero, instead it is coming back with 23304 for the month of January when there were no "AUT" completed in less than 19 days. What have I done and how do I fix it? I also need the # of "AUT" between 4 and 5 and Greater than 6. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
Formula problem on network | Excel Discussion (Misc queries) | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions |