Non-Array Function result in non-accurate values

S

Salman

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$536='Matrix
REPORT'!$C6)*(Matrix!$E$6:$E$536='Matrix REPORT'!$E6)*Matrix!$H$6:$H$536)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array subtitute 4
SUMPRODUCT calculating difference between column values 8
Multiple levels of sumif? 3
move data from columns to rows 3
lookup in a matrix 2
Nested IF Function problem for Excel 2003 7
Running totals when letters entered. IF statement 0
Create Formula for Weighted Average in non-consecutive cells 0

Top