how do i only get negative values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Does Excel have a "sumnegative" function like Lotus? 3
How do I limit formula results to positive only? 4
How can I use circular references that are allowed in Lotus 123? 1
Help needed for Excel formula using if, iserr, match and vlookup! 1
percentage negative values in column 4
Exceeding Limit on Nested IF Statements 4
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee 2
Lotus 123 @nsum function equivalent in excel(?) 10

Back
Top