Counting rows based on multiple columns

[Doyle]

Hi everyone. I have two columns of various information and I want to count
the number of rows that have both "accept" in column 1 and "february" in
column 2. I want to avoid having to create another column of data. Thanks
for any help.

 

[Biff]

Try this:

=SUMPRODUCT(--(A1:A10="accept"),--(B1:B10="February"))

Biff