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?
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?