Combining IF statments

[Toocan70]

Hi All, I have used this site quite often and have found the information very helpful, thanks everyone.
I am working on a spreadsheet to track how many iterations of a particular event happen during the week. I have the IF statement, but I continually exceed the allowed amount. Below is the statement:

=IF(D6="TRG-A","1","0")+IF(E6="TRG-A","1","0")+IF(F6="TRG ASSESS","1","0")+IF(G6="TRG ASSESS","1","0")+IF(H6="TRG ASSESS","1","0")+IF(I6="TRG ASSESS","1","0")+IF(J6="TRG ASSESS","1","0")+IF(K6="TRG ASSESS","1","0")+IF(L6="TRG ASSESS","1","0")+
IF(N6="TRG ASSESS","1","0")+IF(O6="TRG ASSESS","1","0")+IF(P6="TRG ASSESS","1","0")+IF(Q6="TRG ASSESS","1","0")+IF(R6="TRG ASSESS","1","0")+IF(S6="TRG ASSESS","1","0")+IF(T6="TRG ASSESS","1","0")+IF(U6="TRG ASSESS","1","0")+IF(V6="TRG ASSESS","1","0")+
IF(X6="TRG ASSESS","1","0")+IF(Y6="TRG ASSESS","1","0")+IF(Z6="TRG ASSESS","1","0")+IF(AA6="TRG ASSESS","1","0")+IF(AB6="TRG ASSESS","1","0")+IF(AC6="TRG ASSESS","1","0")+IF(AD6="TRG ASSESS","1","0")+IF(AE6="TRG ASSESS","1","0")+IF(AF6="TRG ASSESS","1","0")

Each group of 9 statements equates to one day. I need to continue this statement for 2 more days. How do I combine the statement, but retain the individual cell addition. Thanks in advance.

Jeremy

 

[nightcrawler23]

do you want to count the number of "TRG-A" and "TRG ASSESS" ????

 

[Toocan70]

Sorry, should all be the same TRG-A.

 

[nightcrawler23]

use count function.

 

[Toocan70]

Re: Combining IF statements

I knew there would be an easier way, thanks.

 

[Toocan70]

My next hurdle - similar IF statement, but I need to add hours from the cell above the IF cell to get the total:

=IF(D6="TRG DEV",D4,"0")+IF(E6="TRG DEV",E4,"0")+IF(F6="TRG DEV",F4,"0")+IF(G6="TRG DEV",G4,"0")+IF(L6="TRG DEV",L4,"0")+
IF(N6="TRG DEV",N4,"0")+IF(O6="TRG DEV",O4,"0")+IF(P6="TRG DEV",P4,"0")+IF(Q6="TRG DEV",Q4,"0")+IF(V6="TRG DEV",V4,"0")+
IF(X6="TRG DEV",X4,"0")+IF(Y6="TRG DEV",Y4,"0")+IF(Z6="TRG DEV",Z4,"0")+IF(AA6="TRG DEV",AA4,"0")+IF(AF6="TRG DEV",AF4,"0")+
IF(AH6="TRG DEV",AH4,"0")+IF(AI6="TRG DEV",AI4,"0")+IF(AJ6="TRG DEV",AJ4,"0")+IF(AK6="TRG DEV",AK4,"0")+IF(AP6="TRG DEV",AP4,"0")+
IF(AR6="TRG DEV",AR4,"0")+IF(AS6="TRG DEV",AS4,"0")+IF(AT6="TRG DEV",AT4,"0")+IF(AU6="TRG DEV",AU4,"0")+IF(AZ6="TRG DEV",AZ4,"0")

Thanks, Jeremy

 

[nightcrawler23]

Try SUMIF

 

[Toocan70]

Thanks again,