if-statement: How can I check against a cell and it's opposite cell?

mercredi 4 janvier 2017

I'm trying to check if my cells contain a specific text, and if so, if the cell opposite my 'specific text' contains another specific text.

A| B
1, Banana
2, Orange
3, Banana
1, Banana

I want to count the number of occurrences a specific text has the word banana in the cell opposite.

My thought process is something along the lines of =IF(A:A=1,=COUNTIF(B:B,"Banana"),"")

I'm constantly adding in new cells aswell.

I only want the count the number of times a specific text has banana next to it.

How can I do this?

if-statement