PDA

View Full Version : Formula Trouble



chinanomad
03-14-2011, 08:26 PM
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
03-15-2011, 12:01 AM
formula in N7, copied accross to column BT

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

mdmackillop
03-15-2011, 04:32 PM
Check in Help for Absolute and Relative references.

chinanomad
03-16-2011, 05:47 AM
thank you both....much help.