LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jeanette
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with formula in Excel Bill R Excel Worksheet Functions 3 August 15th 05 03:02 AM
Formula problem on network Philip Reece-Heal Excel Discussion (Misc queries) 2 July 1st 05 01:15 PM
problem with Array Formula OrdOff Excel Worksheet Functions 2 June 30th 05 04:57 PM
Problem with formula Sundaram Iyer Excel Discussion (Misc queries) 0 June 1st 05 12:49 AM
Need a formula for this problem Trying to excel in life but need help Excel Worksheet Functions 1 January 12th 05 11:05 AM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"