| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formaula for less than date and name begins with...!!! HELP!!!
IM trying to create a formula that gives me a total count for cells that are
less than 02/05/10 and the name begins with FHLM, heres what i came up with... =COUNTIF(E:E,"="&DATE(1900,1,1))-COUNTIF(E:E,"="&DATE(2010,2,5))+COUNTIF(E:E,DATE( 2010,2,5))-COUNTIF(U:U,"FHLM*") I keep gettin a bunch of ###### or 0, depending on how I move the data around.. Any ideas???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formaula ODD and EVEN | Excel Worksheet Functions | |||
| Logical Formaula | Excel Discussion (Misc queries) | |||
| excel formaula | Excel Discussion (Misc queries) | |||
| What's wrong with my formaula | Excel Worksheet Functions | |||
| Formaula to multiply and add | Excel Worksheet Functions | |||
Threaded Mode
