Add the $ signs

=SUMIF($B$5:$B$81,"3A",$H$5:$H$81)*24

See help on absolute and relative referencing.


Gord Dibben MS Excel MVP


On Wed, 17 Dec 2008 12:15:00 -0800, NEHicks
wrote:

When I put a formula in B87 [=SUMIF(B5:B81,"3A",H5:H81)*24] and then select
B87:B94 and use the Ctrl D function, it will copy the formula but the range
will change by 1 line each time so that B88 will start with the range
(B6:B82, "3A", H6:H82), etc. By the time I reach B94, the formula range is
completely off and I have to go into each formula and manually change the
range back to what it should be.

What am I doing wrong? I need to freeze the formula so that it keeps the
same range.