View Single Post
  #23   Report Post  
Old February 2nd 19, 12:28 AM posted to microsoft.public.excel.worksheet.functions
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Feb 2019
Posts: 1
Default Count If Column A = x and Column B = y

On Tuesday, April 21, 2009 at 10:39:46 AM UTC+10, Chin via wrote:
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

Hi Chin - this works great for two fields, but not for three do you know a workaround for this? Ie I want to count how many letters (Column A), sent to person (Column B), responded to Y or N (Columnn C) Thx