Hi again,
How do you pull the numbers in a column to compare against something using
the sumproduct formula when there may be letters in the column. i have a
column that has letters and numbers. I don't want to manipulate the column
or make new ones on the side. What i'm looking to do is to count all the
numbers that are less than say 5 while ignoring the letters. There would be
some other criteria as well (in another column) but that doesn't matter for
this question.

Ex.

header
1
2
4
6
7

Answer = 2

I've tried using sumproduct(--(isnumber(A:A)5) but it gives a value b/c of
the "Header" text and also it overwrites the actual values.

Thanks again,
Josh