| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
???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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
