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.