Thanks alot Bob!! That worked great..

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A20<B1:B20),A1:A20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nick" wrote in message
...
I need to add up all the numbers in a column that are lower than the
column
next to it. I tried multiple ways with sumif and Sum(if(... The best I
can
come up with is a sum of 0.

Is this possible?