CountIf with 2 criteria possible?

[duketter]

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.

 

[bj]

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