HOW do i get ONLY negative values to add up in a range of cells
Posted by Paul on June 08, 2000 9:54 PM
I am trying to figure out a formula that will take a range of cells and in this range of cells to take only the negative values and add them together and give that number of the sum of negative values in a specified cell. This is to find out how much of a loss I have acquired within a range of cells. If you know what formula or functions can make this happen email me PLEASE.
Posted by jaime on June 10, 0100 11:43 AM
=sum(rng*(rng>0))
or
=sum(if(rng>0,rng))
these are array functions. so press ctrl+shft+enter
when to type them into the cell
