***This is for Microsoft Works Spreadsheet. I couldn't find any other place to get help so I hope I can get some here.***
I am trying to track baseball stats using Microsoft Works Spreadsheet. I want to have a players' name in a row and in the same row, also have his statistics. For instance, Column A will contain a players' name. Column B will contain OBP. Column C will contain SLG. Column D will contain the sum of Column B and Column C. I know how to create the formula so that "Column B (OBP) + Column C (SLG) = Column D (OBP + SLG)".
My problem is making the formulas uniformally the same throughout the spreadsheet. I want to make "Column B + Column C = Column D" throughout the entire spreadsheet. As of right now, I'm having to manually enter the formula into each row. I would like to know if there is a way I can tell Works Spreadsheet to use the same formula in each and every row?
Thanks to anyone who can understand what I mean and give me a solution to me problem.
Bookmarks