how do i format multiple cells to calculate a sum?

  • Thread starter Thread starter sambarron
  • Start date Start date
S

sambarron

hi there, im am relatively new to excel and use it only to enter and
store herd lists for my farming. i have to enter a large amount of
information for each cow but have been told that there is a way to
automate some of the calculations that need to be made. here is an
example

HERD NO M/F COL D--O--B First Check date

10265 M B 05/03/02 01/10/02


the first check date is calculated by the sum "=(E2+210)" Where E2 is
the D.O.B. and 210 being days. the calculation gives the result simply
as a date.

my question is that if i enter the nessesary information such as herd
number and date of birth etc, how could i "tell" every cell under the
First check date column to work itself out using the DOB in the column
next to it and to add the value of 210??
 
Just copy/paste or grab the little handle in the lower right of the cell and
drag down
 
Hi,

In, say F2, enter the formula "=E2+210" (you don't need the brackets here). Then select F2 and drag the little black square in the bottom-right corner of the cell down as far as needed. This is called "fill down". The row number in the formula will adjust automatically.

HTH
Anders Silvén
 
Back
Top