I have a forumla I need to replicate to adjoining cells but it's a little
more complicated that dragging the corner down or accross to the next cells.
This is the forumula:

=SUMIF(September!B4:B500,C61,September!D4:D500)

When I drag it down to the next cell, it copies it thus:

=SUMIF(September!B5:B501,C62,September!D5:D501)
=SUMIF(September!B6:B502,C63,September!D6:D502)
and so on

What I want to do is have it copy like this:

=SUMIF(September!B4:B500,C62,September!D4:D500)
=SUMIF(September!B4:B500,C63,September!D4:D500)
and so on

I have A LOT of cells that this forumla need to be copied to and if I have
to manually change them all, it's going to take weeks. Any ideas?