Copying formulas

[tim2216]

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.

 

[David Biddulph]

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.