I guess that is why sumproduct formula returns the right value, it is comparing cells to cells, not to what the countif is doing...TY for the heads up Kevin !