| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula problems that keep producing a #Value! Error!!
I am trying to get this formula to average the values in row I for all
individuals seen during the year 2008. The formula also acknowledges that it should ignore any cell in row I, if it is blank. For some reason I cant seem to get the formula to work, and I keep getting a #VALUE! error. Any suggestions? Thanks, Dan Below is the formula I originally wrote: =SUMPRODUCT((--(YEAR('Raw Data'!$C$2:$C$3498)=2008)),('Raw Data'!$I$2:$I5000)<0,AVERAGE('Raw Data'!$I$2: $I5000),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for producing one list from another ! | Excel Worksheet Functions | |||
| Name a formula producing an array | Excel Worksheet Functions | |||
| sum formula not working, producing incorrect answers Excel 2003 | Excel Discussion (Misc queries) | |||
| UDF producing #NAME? | Excel Discussion (Misc queries) | |||
| File Sharing Problems - Error Message | Excel Discussion (Misc queries) | |||
Threaded Mode
