Formula - Counting a combination based in two colums

Hi All

I really need help with this, i am rather new to excel. I have tried every formula i can think of and every formula i have found online.


Column A contains a list of products sold (Apples, Oranges, Pears)
Column B contains the week of the month in which that the product was sold (1,2,3,4,5)

I need to count how many time the word "Apple" appears in column A if the number 2 appears in column B next to it.

PLEASE HELP

Thanks for the quick response.

I have tried this formula, but it tells me that i have entered too many arguments. When i try change to countifs the value stays at 0. i dont know if im maybe using the countifs formula wrong.

I found the problem, when i entered the word "apples" in the drop down box i had entered a space after ("apples ". The formula was looking for the word without a space...... i feel really silly now...

to anyone reading this: ensure your formulas search criteria is an exact match to the way you had entered the word/value into the cell.

Thanks you all for your time.