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)