| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Non-Array Function result in non-accurate values
please look at the following and advise that y i am not getting the
accurate values, this formula provide results but not correct, value are ok uptill 4 rows but afterward it is getting the values from next columns which is not refered in this formula (which is obviously wrong), please help =IF(C6="","",IF(ISERROR(SUMPRODUCT((Matrix!$C$6:$C $536='Matrix REPORT'!$C6)*(Matrix!$E$6:$E$536='Matrix REPORT'!$E6)*Matrix!$H$6:$H$536)),SUMIF('SECTOR AVERAGE'!$B$5:$H$715,'Matrix REPORT'!$C6,'SECTOR AVERAGE'!$G$5:$G$715),SUMPRODUCT((Matrix!$C$6:$C$5 36='Matrix REPORT'!$C6)*(Matrix!$E$6:$E$536='Matrix REPORT'!$E6)*Matrix!$H$6:$H$536))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Hide #VALUE! in result of array formula | Excel Worksheet Functions | |||
| How do I extract a single value from the linest array result? | Excel Worksheet Functions | |||
| Using address function result in an array | Excel Worksheet Functions | |||
| Array formula weird result | Excel Discussion (Misc queries) | |||
Hybrid Mode
