Hey guys, <br /><br />Just learnt of this neat Excel function =COUNTIF(range, criteria), which counts the number of your criteria (number or text) in your range.<br /><br />But now I have a question. It's easier if I portray it as an example.<br /><br />X A B<br />1 M P<br />2 M Q<br />3 F Q<br />4 F Q<br />5 F P<br /><br />and so on...<br /><br />With =COUNTIF(B1:B100, "Q"), I can count all those people in Q-party.<br />But now I want to count all the Females(F) in the Q-party. <br />Is there another COUNTIF-ish function that will help me do this easily?<br /><br />Right now, I've resorted to using Column C with =IF(A1="F",1,0)*IF(B1="Q",1,0)<br />and then summing the total.<br /><br />Thanks<br /><br /><span class='edit'>This post has been edited by <b>Limbo</b>: 18 Apr, 2006 - 12:20 PM</span>
</div>
</div>