 |
 | 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 / September 2004Simple but I cannot....
Can I make it any simplier. I want to make a tracking form. The first col. A is customer name and address,Col. B is date of purchase, Col. C is method of payment, Col. D is item, Col. E is Amount and Col. F is total....total is the Amount added to the last amount in the Total, so the total goes up with each Amount entry. Well, I cannot get this to work. In Col F, I type a formula =Total+Amount. Nothing happens, except sometimes when I type this in the space, the heading on the column comes out #Name. This thing is driving me crazy. Are there instructions that can help me with a most basic fuction as this ? TK one way: Assuming the column titles are in row 1, in F2 enter =E2 then in F3 enter =F2+E3 and copy down > Can I make it any simplier. I want to make a tracking form. > The first col. A is customer name and address,Col. B is [quoted text clipped - 14 lines] > > TK So I need to put that in every F column ? There is must be a way to just tell the program to do that in every row in column F. >-----Original Message----- >one way: [quoted text clipped - 28 lines] >> TK >. > So I need to put that in every F column ? There is must be > a way to just tell the program to do that in every row in > column F. there is - you need to put the formula in each cell in column F. That IS "a way to just tell the program to do that in every row "! When you put the formula in F3 move the mouse to the lower right corner of that cell so that a + appears instead of the normal arrow cursor. Then double click the left mouse button. This will copy the formula down provided there are entries in column E. > > So I need to put that in every F column ? There is must be > > a way to just tell the program to do that in every row in > > column F. > > there is - you need to put the formula in each cell in column F. That IS "a > way to just tell the program to do that in every row "! If all your sheets are set up the same, hold your shift key down and select all sheets, enter the formulas as JE told you to, then right click on one of the tabs and select Ungroup. : So I need to put that in every F column ? There is must be : a way to just tell the program to do that in every row in [quoted text clipped - 38 lines] : >> TK : >. If you're using MacXL, or WinXL03, use the List Manager (it's not called List Manager in XL03 - look up "Create a List" in XL Help), and set column F to be a calculated column. Whenever you add a value in the input row, the formula will be entered in column F. > So I need to put that in every F column ? There is must be > a way to just tell the program to do that in every row in > column F Why is this soo difficult, everyone seems to have a different way to do this and I can not make sense of any of them. I can find no way to create a list, or do those other things suggested. Is there not a simple way to have a column be the sum of itself (F) and another column (E)each time E is added to ? I am sure all the suggestions are good, but I do not know this program or the jargon that goes with it. I just want to be able to set up something really simple. I am using Excel 2000. Thanks, TK >-----Original Message----- >Can I make it any simplier. I want to make a tracking form. [quoted text clipped - 16 lines] >TK >. There are a number of ways to solve a problem in Excel and each solutio in itself is valid. What is simple to you may not be simple to th others and vice-versa. Just pick a solution that you are comfortabl with and use it. It is only difficult if you insist it is difficult ... > *Why is this soo difficult, everyone seems to have a > different way to do this and I can not make sense of any [quoted text clipped - 39 lines] > >TK > >. -- Message posted from http://www.ExcelForum.com > Why is this soo difficult, everyone seems to have a > different way to do this and I can not make sense of any [quoted text clipped - 13 lines] > > Thanks, A spreadsheet is just an electronic version of the old analysis paper - (remember that?) in other words, it will not do anything unless you tell it to! if you want a cell to be a calculated cell, you HAVE to put a formula of some sort into it, there is NO other way of getting data automatically into that cell. What you CAN do, is to enter the formula into the first cell in the column, and then copy it down as far as you think your list will extend. If you want to be really clever, you can use an "IF" statement so that until a value is put into the corresponding cell in "E" , the summed cell is blank. >> Why is this soo difficult, everyone seems to have a >> different way to do this and I can not make sense of any [quoted text clipped - 23 lines] > clever, you can use an "IF" statement so that until a value is put > into the corresponding cell in "E" , the summed cell is blank. In addition, you might be well advised to go out and buy a copy of "Excel for Dummies" and do some reading up on what Excel is and how you can do things with it. TK You would best off to go purchase a book on Excel You did not in your earlier postings ask about creating a list, you were asking about making a formula work --- you got many suggestions Is there anyone where you work who can help you??? : Why is this soo difficult, everyone seems to have a : different way to do this and I can not make sense of any [quoted text clipped - 39 lines] : >TK : >. |
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.