hi all,
need some help here, this is my formula for sumproduct,
SUMPRODUCT(--('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$B$2:$B$65005=$A$7)*('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$G$2:$G$65005=$AA$10)*('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$L$2:$L$65005=$A11)*('[ALL OUTLETS JAN-DEC 2015.xls]SALES-ZSDUP'!$M$2:$M$65005))
For my jan to july file the above formula is doing well, but after updating my file "all outlets jan-dec 2015" for august data, i got all results to #N/A,
even my jan to july files was broken,
could you help me figure out what happen or have i done something wrong my file or my formula?
pls see attached file for clearer view.
thank you.
Bookmarks