Countif with "AND"function

  • Thread starter Thread starter Samir Chhibber
  • Start date Start date
S

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
 
Back
Top