Hi,

I'm not going to ask why you want the same formula several times but try this

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

Mike

"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.