| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex if
This formula returns a "false" but should return a number: As an array.....
=IF(AND($I$2:$I$3536"",$H$2:$H$3536"",$H$2:$H$35 36=10/1/2008,$H$2:$H$353611/1/2008),AVERAGE($J$2:$J$3536,"")) Columns I and H are dates. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex If/Then | Excel Worksheet Functions | |||
| Complex Look up | Excel Worksheet Functions | |||
| Complex sum | Excel Discussion (Misc queries) | |||
| Complex sum | Excel Discussion (Misc queries) | |||
| Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Threaded Mode
