Shorter sumproduct formula help

[muhammad susanto]

hi all,

i need some formula more simple and shorter, for this below :

=SUMPRODUCT((B$870=$AO$2:$AO$866)*($AJ$1:$AN$1=$A871)*$AJ$2:$AN$866)

BUT THAT'S FORMULA NOT WORKING...
HELP ME FIGURE IT OUT..

thanks for your helping..........

 

[Drrellik]

from a syntax standpoint it appears to be correct. if it is not working in your sheet or returning an error then can you tell us what about it is not working. and perhaps post some data.

 

[muhammad susanto]

thanks Drrellik....i am missing should be highlighted data area source before....

but i am still confused, why not automatically working in the same area (everything is matching) when formula copy-paste

should be it's work....why SUMPRODUCT other any similar function? Or SUMPRODUCT is only one function in this case....