View Single Post
  #2   Report Post  
Old April 20th 09, 08:03 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,718
Default Count If Column A = x and Column B = y

=SUMPRODUCT((A1:A100="x")*(B1:B100="y"))


"Trish" wrote:

I am trying to use the count function where two conditions in different
columns need to be satisfied and having no luck. Basically I want to look in
the first column to see if it's A, then look in 2nd column to see if it's B,
then count it... is that possible?