Let me suggest something before you get all tied up over-thinking this problem. There's no reason you need to keep those totals on the right or at the bottom of the spreadsheet. She computer doesn't care, and it's a lot more convenient if you keep totals in the left column and on top. I like to keep an empty row and column between data cells and total cells because it is safer.
Like other guys said, the formula to multiply the number in one column by the number in another column is this: =c3*d3 and once you put the = sign in a cell you can point to c3, enter the asterisk in the cell, point to d3, press the enter key and you're done.
You can copy and paste your newly-created formula to the next cell, and the next, etc.
To get a total at the bottom of a column of numbers, select the sigma sign. It looks kind of like an E. Excel will ask you if you are sure. Answer yes by pressing enter again.
send me an email at captgravity(ampersand)hotmail.com and I will send you a small example. I do a lot of spreadsheets at work.
We sell tractor parts! We have the parts you need to repair your tractor - the right parts. Our low prices and years of research make us your best choice when you need parts. Shop Online Today. [ About Us ]
Today's Featured Article - 12-Volt Conversions for 4-Cylinder Ford 2000 & 4000 Tractors - by Tommy Duvall. After two summers of having to park my old 1964 model 4000 gas 4 cyl. on a hill just in case the 6 volt system, for whatever reason, would not crank her, I decided to try the 12 volt conversion. After some research of convert or not, I decided to go ahead, the main reason being that this tractor was a working tractor, not a show tractor (yet). I did keep everything I replaced for the day I do want to restore her to showroom condition.
... [Read Article]
Latest Ad:
1964 I-H 140 tractor with cultivators and sidedresser. Starts and runs good. Asking 2650. CALL RON AT 502-319-1952
[More Ads]
All Rights Reserved. Reproduction of any part of this website, including design and content, without written permission is strictly prohibited. Trade Marks and Trade Names contained and used in this Website are those of others, and are used in this Website in a descriptive sense to refer to the products of others. Use of this Web site constitutes acceptance of our User Agreement and Privacy Policy
TRADEMARK DISCLAIMER: Tradenames and Trademarks referred to within Yesterday's Tractor Co. products and within the Yesterday's Tractor Co. websites are the property of their respective trademark holders. None of these trademark holders are affiliated with Yesterday's Tractor Co., our products, or our website nor are we sponsored by them. John Deere and its logos are the registered trademarks of the John Deere Corporation. Agco, Agco Allis, White, Massey Ferguson and their logos are the registered trademarks of AGCO Corporation. Case, Case-IH, Farmall, International Harvester, New Holland and their logos are registered trademarks of CNH Global N.V.