copying a formula
 

Hello everyone,

I have a formula down one column. It basically repeats (skips 3 rows then
repeats then skips 3 rows...ect. The formula is:
=$I247+1.695-SUM(COUNTIF($B257:$H257,"PTO")*8)

The I column is where the formula is and it has to look up the prior formula
set to get it's figure to get the new result.
Problem:
I have to copy this formula down several times (the scedule for a whole
year) so
it's 300 rows or something. When I copy it I highlight 7 rows and move down
3 rows and past it. - It keeps changing! I thought since I was using the $
then it would lock it and not change. - ?? After I copy it I have to go back
in each cell and make sure the formula points to the right cell. Is there an
easier way?

Thanks,

Rob

copying a formula
 

Rob,

The $ characters in your formula are only locking the column
references, not the row references. Try

=$I$247+1.695-SUM(COUNTIF($B$257:$H$257,"PTO")*8)

The $ in front of the row reference will lock them


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Robb27" wrote in message
...
Hello everyone,

I have a formula down one column. It basically repeats (skips 3
rows then
repeats then skips 3 rows...ect. The formula is:
=$I247+1.695-SUM(COUNTIF($B257:$H257,"PTO")*8)

The I column is where the formula is and it has to look up the
prior formula
set to get it's figure to get the new result.
Problem:
I have to copy this formula down several times (the scedule for
a whole
year) so
it's 300 rows or something. When I copy it I highlight 7 rows
and move down
3 rows and past it. - It keeps changing! I thought since I was
using the $
then it would lock it and not change. - ?? After I copy it I
have to go back
in each cell and make sure the formula points to the right
cell. Is there an
easier way?

Thanks,

Rob