 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Formula question -simple for those who know
Hello I'm trying to add a number that was calculated by means of a formula in one column to the sum of a different column. Example: Column A (running balance) Column B (sum) =+e5+c6-d6 =sum(h1:h8) Col A's number is running balance. I copied the formula down so that the next row changes the formula to =+e6=c7-d7 I want that running balance to add to a sum in another column. I can add the first cell to it, but it doesn't change if the running balance changes. I know that is because it's pointing to that single cell and not the formula. Can this do what I want it to do? Thanks for your help. Not quite sure but if you want try this =sum($h$1:h8)  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hello > I'm trying to add a number that was calculated by means of a formula in [quoted text clipped - 18 lines] > Can this do what I want it to do? > Thanks for your help. Thank you for trying - no that didn't work. I was just throwing numbers out for example. Here is a picture of the real spreadsheet. I'll use simple numbers to get the point across. C D E H 50 1 2 1 51 1 2 1 52 1 1 4 Total The cells in Col E have a formula that I copied down the column so it changes on each row E1+c2-d2 Column h is a list of numbers that are totalled at the bottom. What I want to do is add the current total in Col E to the Total in col H. I want the total to change as Column E changes . Column E would be the variable number. I can get the two numbers to add, but when I go to the next row and make changes, the number stays the same. It just looks to the cell I originally entered in the formula. I hope I was a little clearer this time. I don't know what I'm trying to say which makes your job a lot harder! LOL Thanks for trying! > Not quite sure but if you want try this > =sum($h$1:h8) [quoted text clipped - 21 lines] > > Can this do what I want it to do? > > Thanks for your help. Are you say that you have just one *sum* cell and you want to add the *last* running balance figure in Column A? If so the use: =SUM(H1:H8)+LOOKUP(10^10,A1:A8) SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hello > I'm trying to add a number that was calculated by means of a formula in [quoted text clipped - 18 lines] > Can this do what I want it to do? > Thanks for your help. Thank You!! that worked!! > Are you say that you have just one *sum* cell and you want to add the *last* > running balance figure in Column A? [quoted text clipped - 25 lines] > > Can this do what I want it to do? > > Thanks for your help. Glad to help. Thanks for the feedback SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Thank You!! that worked!! > [quoted text clipped - 30 lines] >> > Can this do what I want it to do? >> > Thanks for your help.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.