software

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?

=SUMPRODUCT(--(A1:A20lt;B1:B20),A1:A20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Nickquot; gt; wrote in message
...
gt; I need to add up all the numbers in a column that are lower than the
column
gt; next to it. I tried multiple ways with sumif and Sum(if(... The best I
can
gt; come up with is a sum of 0.
gt;
gt; Is this possible?
Thanks alot Bob!! That worked great..

quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT(--(A1:A20lt;B1:B20),A1:A20)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Nickquot; gt; wrote in message
gt; ...
gt; gt; I need to add up all the numbers in a column that are lower than the
gt; column
gt; gt; next to it. I tried multiple ways with sumif and Sum(if(... The best I
gt; can
gt; gt; come up with is a sum of 0.
gt; gt;
gt; gt; Is this possible?
gt;
gt;
gt;