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

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:A20<B1:B20),A1:A20)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nick" <Nick@discussions.microsoft.com> wrote in message
news:A47EE9FA-AA0C-41AC-BF0D-266344E63242@microsoft.com...
> 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?

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" <Nick@discussions.microsoft.com> wrote in message
> news:A47EE9FA-AA0C-41AC-BF0D-266344E63242@microsoft.com...
> > 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?
>
>
>