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 - A Question for Dads This recent topic from the Tractor Talk discussion board is being highlighted because it is an awesome display of the caliber of individuals that have made this site their own. The young person asking questions received positive feedback and advice from total strangers who "told it like it is" with the care many reserve for their own kids. The advice is timeless... so although it isn't necessarily antique tractor related, it will be prominently displayed in our archives to honor those who have the courage to ask and those who have the courage to respond in an honest, positive manner.
... [Read Article]
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.
