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.