Forum Discussion
Solved
Countifs
Hi. I have an issue with countifs if you could help me , thats I need with multiple condition Kindly find the attached file The condition is count groups under 50% in ratio and in the same time ign...
Hi Mohammed,
You check cells by groups of 3, you may count such groups by
=SUMPRODUCT(($G$4:$DT$4="Target")*(G5:DT5>=11)*(OFFSET(G5:DT5,0,2)<0.5))
where first condition finds first cell in the group, second check if first cell is not below the 11 and third one adds if third cell in the group is less than 50%. Calculated range shall be two cells less than actual one.
Attached.
Hi Mohammed,
You check cells by groups of 3, you may count such groups by
=SUMPRODUCT(($G$4:$DT$4="Target")*(G5:DT5>=11)*(OFFSET(G5:DT5,0,2)<0.5))
where first condition finds first cell in the group, second check if first cell is not below the 11 and third one adds if third cell in the group is less than 50%. Calculated range shall be two cells less than actual one.
Attached.