Countif with "AND"function

[Samir Chhibber]

Hi I am working on this spreadsheet, where I have 2 columns. The first
column has a numerical value, in a random order (ranging from 1-6) and the
second column had alphabets again in a random order (ranging from A-F).

This what I am trying to do

I need a count of number of 3's (first column) which have a value of F

So, in effect there are 2 searches, first one in column one is looking for
the number 3 and the second one is looking for the letter F in column two,
with the combination that these letter F's should also have a value of 3 in
column one as well

Need help ASAP

Thanks

 

[Frank Kabel]

Hi
use
=SUMPRODUCT(--(A1:A10=3),--(B1:B10="F"))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html