| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count problem
Hi Domenic
I was just about to post to say that I came up with an incorrect result , but you beat me to it . Your new formula works perfect all the way down to 500 rows , no errors ! You are a gentleman and genius. Thank you very much ! regards bill -- bill gras "Domenic" wrote: Bill, The formula will return an incorrect result when a sequence does not contain a number greater than 35. Therefore, try the following formula instead... =IF(ISERR(AU38),COUNTIF(AU39:INDEX(AU39:$AU$500,MA TCH(TRUE,IF(ISNUMBER(AU 39:$AU$500),AU39:$AU$50035,ISERR(AU39:$AU$500)),0 )),"<=35"),"") ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , bill gras wrote: Hi Domenic Thanks for your reply and your time , your fomula works perfect Once again thanks regards bill -- bill gras |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Datedif incorrect month count - February problem?? | Excel Worksheet Functions | |||
| How to count uniques of a SUMPRODUCT subset? | Excel Worksheet Functions | |||
| Count With Date Problem | Excel Worksheet Functions | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
| Count data entries and date problem | Excel Worksheet Functions | |||
Threaded Mode
