copying a formula

R

Robb27

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
 
C

Chip Pearson

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
 
Top