 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Copying 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. 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.  SignatureDavid Biddulph > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.