Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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"?
Can you enclose your formula in paren's and then add *-1. That's how I do it in excel.
Yes, I can close in ( ) and multiply by -1 to change the sign; that works as well. Thant may be cleaner and more easily understood by reviews of the sheet. Thanks
Thanks
