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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ???Sumif(Range1,Range1<Range2,Range1)??? (https://www.excelbanter.com/excel-discussion-misc-queries/82969-sumif-range1-range1-range2-range1.html)

Nick

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

Bob Phillips

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

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

Nick

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

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?

All times are GMT +1. The time now is 11:12 PM.