Posted to microsoft.public.excel.newusers

tim2216

external usenet poster

Posts: 6

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying formulas	newyorkjoy	Excel Discussion (Misc queries)	4	February 27th 07 12:22 AM
copying formulas	Woody	Excel Discussion (Misc queries)	8	August 21st 06 09:47 PM
copying formulas	Mark Goodwin	Excel Worksheet Functions	2	May 11th 05 05:31 PM
copying formulas	Boz	Excel Worksheet Functions	1	March 1st 05 06:47 PM
Copying Down Formulas Q	John	Excel Worksheet Functions	4	November 23rd 04 11:14 PM

All times are GMT +1. The time now is 02:57 PM.

About Us

"It's about Microsoft Excel"