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 ignore the groups the target below 11 carton
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 ignore the groups the target below 11 carton
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.
2 Replies
- Many thanks
It's working 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.
