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)))

Non-Array Function result in non-accurate values
 

To serve as reference, the SumIf formula syntax is:
SumIf(range, criteria, sum_range)

Your range argument is $B$5:$H$715 while your sum_range argument is
$G$5:$G$715. The first has 7 columns while the second has only 1 resulting in
a noncorrespondence. This seems likey a source of error.

Regards,
Greg

"Salman" wrote:

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)))