View Single Post
  #4   Report Post  
Old April 21st 09, 01:39 AM posted to microsoft.public.excel.worksheet.functions
Chin via Chin via is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2009
Posts: 13
Default Count If Column A = x and Column B = y

Trish, please try:


Please advise if that is what you were looking for.

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?

Message posted via