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?