Copying formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to copy this to about 700 cells?

=SUMPRODUCT((A4:A11998=S6)*(B4:B11998=V3))

there has to be an easier way to copy this.
 
Easier than what? Copy and paste? Or drag to fill?

If you want exactly the same in all 700 cells, make the cell references in
the formula absolute & it will copy without change. [But why would you want
to do that?]
If you want any or all of the references to change as the rows or copies
change, make the relevant parts relative addresses.
 
Back
Top