Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Changing sign of a Sumif or Sumifs result

John Sitton
edited 12/09/19 in Archived 2016 Posts

Is there a "proper" way to change the sign for SUMIF or SUMIFS formula results. I have found that


=-SUMIF()  doesn't work; but, that = 0 - SUMIF() does. Is there a way to do it without the "0"?





This discussion has been closed.