'smart' dragging

[Spheon]

how can i enter this formula in the spreadsheet so I can
drag it where the A2 only changes relative to the cell ie

=SUMPRODUCT((Invoices!A5:A1000=A2)*(Invoices!G5:G1000))
drag this one to get....
=SUMPRODUCT((Invoices!A5:A1000=A3)*(Invoices!G5:G1000))
=SUMPRODUCT((Invoices!A5:A1000=A4)*(Invoices!G5:G1000))
etc when I drag all the figures change to this
=SUMPRODUCT((Invoices!A6:A1001=A23)*(Invoices!G6:G1001)) etc



thanks in advance

 

[Mike H]

Use absolute references

=SUMPRODUCT((Invoices!$A$5:$A$1000=A2)*(Invoices!$G$5:$G$1000))

Mike

 

[Spheon]

thanks....all this time and now I know the difference