drag to copy and change only middle number

[TiggerTwo]

HI, I have the following formula :
=SUMIF(DOME!E170:E173,B20,DOME!F170:F173)

I would like to put my cursor over the cell of this formula an
click/drag/copy it down the column. In that process I would like onl
the middle number to change incrementally by 1 (i.e. B21, B22, etc..)
How do I do this?
And , if I later do a sort will it screw up the middle number?
So far when I've tried it, the outer numbers keep changing. ugh!

thanks
Regards
BAr

 

[Norman Harker]

Hi Barb!

Change the formula to:

=SUMIF(DOME!$E$170:$E$173,B20,DOME!$F$170:$F$173)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
try
=SUMIF(DOME!$E$170:$E$173,B20,DOME!$F$170:$F$173)

also have a look at
http://www.cpearson.com/excel/relative.htm
for explaining absolute and relative references