Formula to long

You can use a formula like this

=SUM((MMULT(ISNUMBER(SEARCH({"BM","ENG"},'T-WEEK DATA'!G6:G2283))*('T-WEEK DATA'!U6:U2283="T-9"),LEN({"BM";"ENG"})^0)>0)+0)

You can expand the {"BM","ENG"} parts as much as you like - Note that the first array constant uses comma separators, the second uses semi-colons.

MMULT is limited to 5461 rows in Excel 2003

.......or if you list all 30 criteria in a column range, e.g. Z1:Z30 on same sheet as formula then you can use this version

=SUM((MMULT(ISNUMBER(SEARCH(TRANSPOSE(Z1:Z30),'T-WEEK DATA'!G6:G2283))*('T-WEEK DATA'!U6:U2283="T-9"),LEN(Z1:Z30)^0)>0)+0)

That needs to be confirmed with CTRL+SHIFT+ENTER

Edit: I deleted your duplicate post