| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif formula perhaps
Hi Howard,
Am Sat, 18 Aug 2012 21:17:42 -0700 (PDT) schrieb : Here is a sample of entries for Data1. With 4 in the drop down cell P1 I would expect to return the value 5. =COUNTIF(Data1,P1) returns 0 (zero). 123456789 456 234 123 4 479 5 149 289 try: =COUNT(SEARCH(P1,Data)) and enter the array formula with CTRL+Shift+Enter In your example I see 6 times the 4 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
| help in countif formula. | Excel Discussion (Misc queries) | |||
| countif formula | Excel Discussion (Misc queries) | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| Countif formula and then some... | Excel Worksheet Functions | |||
Threaded Mode
