View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Count If equals x AND y

I need to count all the cells in Col C if
Col A=1 and Col B=No


Ok, what's the criteria for cells in column C?

--
Biff
Microsoft Excel MVP


"Nadine" wrote in message
...
Excel 2003
Col A Col B Col C
1 No Count this cell

I need to count all the cells in Col C if Col A=1 and Col B=No

Thanks.