U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 06-13-2011, 04:56 PM
 
Location: Clearwater, FL
210 posts, read 418,105 times
Reputation: 193

Advertisements

I am having an issue with subtracting from 1 main cell using multiple cells and printing to another cell.

I would like to subtract from the cell that has the starting balance and print it to the yellow cell by taking from the payment cells. the only way I can get it to do it is by pasting a formula in multiple cells but then it will print the remaining balance and I dont want it to do that since it will clutter up the spreadsheet incase I need to use those areas for additional information.

Any and all help is appreciated.

Here is an image to help with my terrible explanation.



Uploaded with ImageShack.us

I would like it to look like this.



Uploaded with ImageShack.us
Reply With Quote Quick reply to this message

 
Old 06-13-2011, 05:08 PM
 
Location: Wandering.
3,545 posts, read 5,681,436 times
Reputation: 2659
Quote:
Originally Posted by Nic. View Post
I am having an issue with subtracting from 1 main cell using multiple cells and printing to another cell.

I would like to subtract from the cell that has the starting balance and print it to the yellow cell by taking from the payment cells. the only way I can get it to do it is by pasting a formula in multiple cells but then it will print the remaining balance and I dont want it to do that since it will clutter up the spreadsheet incase I need to use those areas for additional information.

Any and all help is appreciated.

Here is an image to help with my terrible explanation.



Uploaded with ImageShack.us

I would like it to look like this.



Uploaded with ImageShack.us

If I understand the question correctly, I think that a simple sum would work:

Assuming that the "Start Balance" cell is F2, and the yellow cell is G2, I'd use the following in the yellow cell:

=F2-SUM(E4:E10)

You'd have to adjust the end cell in the sum (E10) to be further down the sheet, but could potentially move it to E100 or something way down the sheet.

If I'm off on the cells (the picture doesn't have the row numbers displayed), you may have to change the cells in the formula.
Reply With Quote Quick reply to this message
 
Old 06-14-2011, 08:48 AM
 
Location: Cleveland, Ohio
11,832 posts, read 13,968,972 times
Reputation: 8073
Quote:
Originally Posted by Skunk Workz View Post
=F2-SUM(E4:E10)
I don't think you even need the SUM in there.

=F2-(E4:E10)
Reply With Quote Quick reply to this message
 
Old 06-15-2011, 09:06 AM
 
Location: Clearwater, FL
210 posts, read 418,105 times
Reputation: 193
Quote:
Originally Posted by Skunk Workz View Post
If I understand the question correctly, I think that a simple sum would work:

Assuming that the "Start Balance" cell is F2, and the yellow cell is G2, I'd use the following in the yellow cell:

=F2-SUM(E4:E10)

You'd have to adjust the end cell in the sum (E10) to be further down the sheet, but could potentially move it to E100 or something way down the sheet.

If I'm off on the cells (the picture doesn't have the row numbers displayed), you may have to change the cells in the formula.
Worked perfectly.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Follow City-Data.com founder on our Forum or

All times are GMT -6. The time now is 09:59 PM.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top