Có pro nào rút gọn được công thức này giúp e không?
=COUNTIFS('NANG SUAT'!$GN$11:$GN$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$GP$11:$GP$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$GR$11:$GR$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$GT$11:$GT$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$GX$11:$GX$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$GZ$11:$GZ$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$HB$11:$HB$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!$HD$11:$HD$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)+COUNTIFS('NANG SUAT'!GV$11:$GV$1479,">0",'NANG SUAT'!$H$11:$H$1479,'THAM NIEN'!HP$7,'NANG SUAT'!$F$11:$F$1479,'THAM NIEN'!$C8,'NANG SUAT'!$D$11:$D$1479,'THAM NIEN'!$B8)
