This goes in a cell that's not in the range you're inspecting:
=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(A1:A105))

(I didn't understand your last comment.)

And you can only use the entire column in xl2007.

jxbeeman wrote:

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

--

Dave Peterson