multiple requirements for Countif statment

is there a way to put multiple requirement for a countif statment, for example I want to it to do a count of two columns, if column 1 has the correct number, for example "500" then it will do a count of column 2 which would have a different criteria, for example "apples".


500 apple
600 orange
500 apple
100 banana
500 cherry
600 apple

so for the example above I would want a count of 2. two occurances of apple in department 500. Anyway we can do this, two criterias?

Try...

=SUMPRODUCT(--($A$1:$A$6=500),--($B$1:$B$6="Apples"))

OR

=SUMPRODUCT(--($A$1:$A$6=D1),--($B$1:$B$6=E1))

...where D1 contains your first criterion, such as 500, and E1 contains your second criterion, such as Apples.

Hope this helps!