Copying formulas
 

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.

Copying formulas
 

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.
--
David Biddulph

"tim2216" wrote in message
...
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.