Sum with ABS?

[suzy~wow]

I'm sure this can be done but I don't think I have the formula correct. What I am trying to do is add each day's total while displaying a positive number if the total exceeds 6000.
Please Help!?!
Thank you so much!

ABS,sum(B82,B93,B104,B115,B126,B137)-6000

[Ron Coderre]

I think this might be an easier approach.....

Replace each day's SUM function with the SUBTOTAL function.
Example:
If the formula in B82 is =SUM(B50:B79)

Change it to =SUBTOTAL(9,B50:B79)
...Note: the 9 indicates that we want a SUM (vs an AVERAGE, MIN, etc)

The SUBTOTAL function ignores other SUBTOTAL functions within it's range.
Then, your final formula could be something like:

Please Login or Register  to view this content.

or...if you only want to display a value when the total exceeds 6000....

Please Login or Register  to view this content.

Is that something you can work with?

Please Login or Register  to view this content.

[suzy~wow]

Hi!

It doesn't work. Below I have given you all of the totals for the cells...

B82 = 13.96
B93 = 2616.14
B104 = 1780.76
B115 = 1282.63
B126 = 402.83
B137 = 0.00

In cell B144 I would like to have the above totals added together, yet have the total reflect 96.32 (which exceeds the 6000 goal). When I enter the formula I get an 18,000 total. I would like the cell to reflect a positive balance of 96.32.

Does that make sense?
If not let me know where the confusion is?
Thank you so much for your help,
Suzy

[daddylonglegs]

Your original formula is almost there......

=ABS(SUM(B82,B93,B104,B115,B126,B137)-6000)

[suzy~wow]

See I told you! YOU ROCK!

[suzy~wow]

It's solved