Counting rows based on multiple columns
 

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.

Counting rows based on multiple columns
 

Try this:

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

Biff

"Doyle" wrote in message
...
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.