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

Kelli Frattini-Adams

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.

Paul Newcome

Try subtracting it from zero

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

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. 👍️