Nguyen Anh Dung
Board Regular
- Joined
- Feb 28, 2020
- Messages
- 180
- Office Version
- 2016
- Platform
- Windows
i have sheet NgocBich
i have sheet BCTH_BacKup
i have use formular result #NA
=IF(SUMPRODUCT(INDIRECT((CONCATENATE($A3)&"!$B$3:$B$360"=$B3)*(INDIRECT(CONCATENATE($A3)&"!$D$3:$V$360"="x")*(INDIRECT(CONCATENATE($A3)&"!$C$3:$C$360">=$B$1)*(INDIRECT(CONCATENATE($A3)&"!$C$3:$C$360"<=$D$1)*(INDIRECT(CONCATENATE($A3)&"!$D$2:$V$2"=C$2))))))>0,"x",""))
best regards,
Nguyen Anh Dung
i have sheet BCTH_BacKup
i have use formular result #NA
=IF(SUMPRODUCT(INDIRECT((CONCATENATE($A3)&"!$B$3:$B$360"=$B3)*(INDIRECT(CONCATENATE($A3)&"!$D$3:$V$360"="x")*(INDIRECT(CONCATENATE($A3)&"!$C$3:$C$360">=$B$1)*(INDIRECT(CONCATENATE($A3)&"!$C$3:$C$360"<=$D$1)*(INDIRECT(CONCATENATE($A3)&"!$D$2:$V$2"=C$2))))))>0,"x",""))
best regards,
Nguyen Anh Dung