Formula Trouble

[chinanomad]

I have created formulas which I what to copy and paste along a few rows, but when I do the formula changes and I have to manually fix it.

For Example

Cell Q7 =SUMIFS(F:F,B:B,"POitem",A:A,"<="&EOMONTH($Q1,0),A:A,">"&EOMONTH($P1,0))

I want to copy this to cell R7, but when I do it looks like this

=SUMIFS(G:G,C:C,"POitem",B:B,"<="&EOMONTH($Q1,0),B:B,">"&EOMONTH($P1,0))

but it should look like
=SUMIFS(F:F,B:B,"POitem",A:A,"<="&EOMONTH($R1,0),A:A,">"&EOMONTH($Q1,0))

Why is this happening? How can it be fixed so I don't have to manually enter all the formulas?

[mancubus]

formula in N7, copied accross to column BT

[vba]=SUMIFS($F:$F,$B:$B,"POitem",$A:$A,"<="&EOMONTH(N$1,0),$A:$A,">"&EOMONTH(M$ 1,0))[/vba]

[mdmackillop]

Check in Help for Absolute and Relative references.

[chinanomad]

thank you both....much help.