I am trying to create a formula so that the information will pull to show us how many people we can anticipate in a certain program date based on their expected completion date for studies. And then once they have been hired how many people will actually be in the training session.
this is the formula I have but it does not seem to be working.
=IF($E$10<=$N$1,COUNTIFS('Direct Hires'!$H:$H,$E$10,'Direct Hires'!$M:$M,"*"&$A43&"*",'Direct Hires'!$L:$L,"<>Firm"),COUNTIFS('LTP Candidates'!$H:$H,"*"&$A43&"*",'LTP Candidates'!$V:$V,"=1",'LTP Candidates'!$A:$A,"<>Firm")+COUNTIFS('LTP Candidates'!$H:$H,"*"&$A43&"*",'LTP Candidates'!$T:$T,"=1",'LTP Candidates'!$A:$A,"<>Firm")+COUNTIFS('LTP Candidates'!$H:$H,"*"&$A43&"*",'LTP Candidates'!$U:$U,"=1",'LTP Candidates'!$A:$A,"<>Firm"))
