Using the same formula throughout the spreadsheet.

  • Thread starter Thread starter Brandon13830
  • Start date Start date
B

Brandon13830

***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.
 
Back
Top