how do i only get negative values
 

Hi

Currently converting my spreadsheets from lotus 123. one of the formulas I
use is sumnegative - where it only displays totals that add up to 0 or less,
but there is nothing on excel that does the same thing. Any sujestions?

how do i only get negative values
 

Looks like:

=SUMIF(Range,"<0")

2 cordeaux close wrote:
Hi

Currently converting my spreadsheets from lotus 123. one of the formulas I
use is sumnegative - where it only displays totals that add up to 0 or less,
but there is nothing on excel that does the same thing. Any sujestions?