Hi,

You could try this

=SUMPRODUCT(ISNUMBER(D3:D9)*ISNUMBER(E3:E9)*(D3:D9 E3:E9))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Johndb" wrote in message
...
Please help.

I have two colums of data I need to compare, roughly 100 rows each. I
need
to count a given row if the value in column b is greater than the number
in
column a. There are a few alpha letters in each row. I have scoured and
tested everything I have seen posted regarding countif, sumif, sumproduct,
etc. and I can't seem to get it to work. Any assistance would be greatly
appreciated.

Thanks in advance,

John