I want to return a negative number as this sheet will be used for our accounts payable team.

I'm using a simple Sum formula. I want to display this as a negative. conditional formatting to change the color will not work. It needs to either be -$192,000 or (192,000)

=SUM([2021 Total]1:[2021 Total]46) = 192,000

I've tried sumIF with no luck too.

it's really just adding up all the values but I need the total to be negative. Please help.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try subtracting it from zero

=0 - SUM([2021 Total]1:[2021 Total]46)

All comments

Paul Newcome

Try subtracting it from zero

=0 - SUM([2021 Total]1:[2021 Total]46)

Kelli Frattini-Adams

@Paul Newcome Yes!! I knew there was something simple I was missing. Think my brain is tired b/c I tried some combo of that but had the 0 in incorrect place. Anyway, this worked perfectly, thanks for quick response!😁

Paul Newcome

No worries. Sometimes it is good to take a step back or ask for another set of eyes. After a while you get so used to the complicated bits that the easy bits become impossible. Haha

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.