Dear excel experts,
Lately, I've learned from the answers to my previous posts of the sumproduct function, and so therefore, I'd like to continue using it. My problem is, I'm struggling with adding another 2 conditions to my prexisiting formula because I do not know where to put the parentheses so that these two conditions are added.
In the attached excel, I've managed to write out this entire formula =SUMPRODUCT((((($B$2:$B$121="Yes")*($F$2:$F$121=4)*((($C$2:$C$121=1)*(LEN($D$2:$D$121)>0)*($D$2:$D$121<>6)) +(((($C$2:$C$121=2)* (LEN($D$2:$D$121)>=3)*(MID($BJ$2:$BJ$121,3,1)<>"6"))))))))), and if you see in my excel sheet, the answer that I got is 119. This is correct so foar. However, I need to add two more conditions to this formula by only counting the cases whose scores are >=0 and <=10 (located in column G of my excel attachmenet), and therefore, my count should now go down to 116. How do I do that? I think I lose control of where to put the parentheses after so many conditions.
I'd appreciate any instructions you can provide. Thank you so much for your time!
Anita
Bookmarks