Hi

This question has probably been asked (and answered) a million times...

I have the following sheet
A B
Peas 1 Aug
Peas 2 Aug
Beans 1 Aug
Peas 2 Aug
Beans 2 Aug

I want a formula that can tell me how many times the word "Peas" appears for
a specific date (eg 1 Aug).

My worksheet has hundreds of rows of information and I do not want sort. I
want to type in the word "Peas" and it should give a total.

Thanks in advance