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 - Third Brush Generators - by Chris Pratt. While I love straightening sheet metal, cleaning, and painting old tractors, I use every excuse to avoid working on the on the electrics. I find the whole process sheer mystery. I have picked up and attempted to read every auto and farm electrics book with no improvement in the situation. They all seem to start with a chapter entitled "Theory of Electricity". After a few paragraphs I usually close the book and go back to banging out dents. A good friend and I were recently discussing our tractor electrical systems when he stated "I figure it all comes back to applying Ohms Law". At this point
... [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.