Simplify this formula containing sum(countifs() function

[gfdwer2]

I NEED THIS FORMULA TO BE SIMPLIFIED BECAUSE IT TAKES A LOT OF TIME FOR EXCEL TO COMPUTE IT

Simple background, I need to count all the cells containing "OT 1","OT 2","OT 3","OT 4","OT 5","OT 6" from 7 columns (PROC1-7) , but only for a specific date (represented by A5)

=SUM(COUNTIFS(DATE,A5,PROC1,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))+SUM(COUNTIFS(DATE,A5,PROC2,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))+SUM(COUNTIFS(DATE,A5,PROC3,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))+SUM(COUNTIFS(DATE,A5,PROC4,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))+SUM(COUNTIFS(DATE,A5,PROC5,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))+SUM(COUNTIFS(DATE,A5,PROC6,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))+SUM(COUNTIFS(DATE,A5,PROC7,{"OT 1","OT 2","OT 3","OT 4","OT 5","OT 6"}))

FROM THE FORMULA ABOVE:
1. DATE is a range selection which is Column A from different sheet (DATA)
2. Content of Cell A5 is the first criteria I am looking for in range DATE
3. PROC1 is a range selection which is Column H from different sheet (DATA)
PROC2 is a range selection which is Column K from different sheet (DATA)
PROC3 - PROC7 so on and so forth
4. "OT 1" - "OT 6" are the text I am looking for in range PROC1-PROC7

I have to separate EACH PROC (Column H, Column K, so on so forth) because excel does not allow me to use all the columns at once like H:Z

sample excel sheet can be found in this link: sample.1.xlsm

 

[gfdwer2]

You can simplify with a wildcard then:

=COUNTIFS(DATE,A5,PROC1,"OT *")+COUNTIFS(DATE,A5,PROC2,"OT *")+COUNTIFS(DATE,A5,PROC3,"OT *")+COUNTIFS(DATE,A5,PROC4,"OT *")+COUNTIFS(DATE,A5,PROC5,"OT *")+COUNTIFS(DATE,A5,PROC6,"OT *")+COUNTIFS(DATE,A5,PROC7,"OT *")

YOU ARE THE BOSS THAT ACTUALLY WORKED!!!

 

[gfdwer2]

You can simplify with a wildcard then:

=COUNTIFS(DATE,A5,PROC1,"OT *")+COUNTIFS(DATE,A5,PROC2,"OT *")+COUNTIFS(DATE,A5,PROC3,"OT *")+COUNTIFS(DATE,A5,PROC4,"OT *")+COUNTIFS(DATE,A5,PROC5,"OT *")+COUNTIFS(DATE,A5,PROC6,"OT *")+COUNTIFS(DATE,A5,PROC7,"OT *")

IT DID ACTUALLY SIMPLIFIED THE FORMULA, THE THING IS, I STILL NEED TO LIMIT MY RANGE.