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