I am attempting to combine 2 countifs formulas and then divide them by another countif and am getting 240% and I cant figure out what I am doing wrong. Below are the countifs that I am trying to combine and the third is the one I am trying to divide by. For reference the first set of formulas result is 4 and the second formulas result is 5.
=COUNTIFS(Chlorine_Temp!$A39:$A41,">6/30/2019",Chlorine_Temp!$A39:$A41,"<8/1/2019",Chlorine_Temp!I39:I41,">.5")+COUNTIFS(Chlorine_Temp!A42:A43,">6/30/2019",Chlorine_Temp!A42:A43,"<8/1/2019",Chlorine_Temp!J42:J43,">=.5")
=COUNTIFS(Chlorine_Temp!$A:$A,">6/30/2019",Chlorine_Temp!$A:$A,"<8/1/2019")
=COUNTIFS(Chlorine_Temp!$A39:$A41,">6/30/2019",Chlorine_Temp!$A39:$A41,"<8/1/2019",Chlorine_Temp!I39:I41,">.5")+COUNTIFS(Chlorine_Temp!A42:A43,">6/30/2019",Chlorine_Temp!A42:A43,"<8/1/2019",Chlorine_Temp!J42:J43,">=.5")
=COUNTIFS(Chlorine_Temp!$A:$A,">6/30/2019",Chlorine_Temp!$A:$A,"<8/1/2019")