Counting rows based on multiple columns Doyle 29.09.2006 18:03:01 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.

Re: Counting rows based on multiple columns "Biff" <biffinpitt[ at ]comcast.net> 29.09.2006 18:06:31 Try this: =SUMPRODUCT(--(A1:A10="accept"),--(B1:B10="February")) Biff "Doyle" <Doyle[ at ]discussions.microsoft.com> wrote in message news:8BE26E40-F715-4E11-8E68-B0AEDC137791[ at ]microsoft.com... [Quoted Text] > 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.