the only problem with that Kevin is that there are only 5 values in column A that are less than the column B values... rows 3,8,9,14,16.. so where does the 6TH < come from? Sumproduct and array entered sum(if(.. both produce the proper result, so why does COUNTIF give 1 extra?