???Sumif(Range1,Range1<Range2,Range1)???

N

Nick

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?
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
N

Nick

Thanks alot Bob!! That worked great..

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Top