View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default CountIf with 2 criteria possible?

try
=sumproduct(--(B1;B100=criteria1),--(C1:C100<0))
the --( changes the logical true false to numeric 1 0
the arrays must be the same size and cannot refer to a full column for pre
2007

"duketter" wrote:

Microsoft 2003 - I am trying to do a count of the number of cells that match
my criteria by using the countif command. However, I need it to look at 2
separate criteria items before a match is made. It needs to look in column
B:B first to make sure the criteria is there and then needs to look in column
C:C to make sure the value for that cell is not equal to 0. If those
criteria both match, I want it to bring back the total number of cells this
is true for.