View Single Post
  #6   Report Post  
Old April 21st 09, 02:15 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
First recorded activity by ExcelBanter: Jan 2008
Posts: 2,389
Default Count If Column A = x and Column B = y

This works only in Excel 2007. You should identify this when you are using
functions found only in the newest version.


"Chin via" <[email protected] wrote in message
news:[email protected]
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
the first column to see if it's A, then look in 2nd column to see if it's
then count it... is that possible?

Message posted via