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 - Good As New - by Bill Goodwin. In the summer of 1995, my father, Russ Goodwin, and I acquired the 1945 Farmall B that my grandfather used as an overseer on a farm in Waynesboro, Georgia. After my grandfather’s death in 1955, J.P. Rollins, son of the landowner, used the tractor. In the winter 1985, while in his possession the engine block cracked and was unrepairable. He had told my father
... [Read Article]
Latest Ad:
2022 John Deere 5045E, 4wd, front end loader and 3rd function with grapple. 120 hrs, 55k new, must sell
[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.