Another Tally question...

  • Thread starter Thread starter onesidered
  • Start date Start date
O

onesidered

I have data in cells C4:C27
The data is equivilant to Dollars and cents
I have the budget amount at the bottom of my worksheet as $5,000
As I input data into the C column, it updates the bottom # by
subtracting from it.
Example: $50 in C updates total to -$4950

My question - I am currently using this formula =SUM(C4:C27)-5000 and I
would like for my $5000 to be a positive number instead of -$5000. Then
when I go over that amount it will turn into a negative number. Can
anyone help?

I should be able to figure this out, but I have brain fry today.

Thanks,
T.
 
Haven't seen your other post, hopefully people replied there with something
like,

Just turn the arguments around and write it as:
=5000-SUM(C4:C27)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alternative to array formula to get answer? 4
Autofill from months 0
Column sum incorrect upon subtracting 6
copy data from varying slected rows into new spreadsheet 2
Complicated Mail Merge that is over my head. 1
XIRR question 5
Another sumproduct question 3
Running tally comparing two columns in unsorted list 7

Back
Top