Thầy cho em hỏi hàm if kết hợp với vlookup như dạng này là thế nào ạ:
=IFERROR(VLOOKUP($B4,'T12'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T1'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T2'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T3'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T4'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T5'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T6'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T7'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T8'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T9'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T10'!$C$8:$BV$111,39,0),0)+IFERROR(VLOOKUP($B4,'T11'!$C$8:$BV$111,39,0),0)