Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

Copy formulas

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
STS - 23 Mar 2008 22:35 GMT
I need to copy a formula from column I to column J, and would like to do the
following:
Column I                         Column J
=SUM((APR!C4))              =SUM((MAY!C4))

Basically, when I copy I would like to add 1 month, but leave the cell (C4)
the same. When I try it, the month always stays the sam, but the cell changed
from C4 to D4. I would like to know how to copy the above forumula in Colum I
so the result will be the formula above in Column J.

Thank you for any help.
Simon
Jarek Kujawa - 23 Mar 2008 22:56 GMT
suppose you have a list of months in the 3rd row, then:

=SUM(INDIRECT(C3&"!C4")

change C3 appropriately

> I need to copy a formula from column I to column J, and would like to do the
> following:
[quoted text clipped - 8 lines]
> Thank you for any help.
> Simon
art - 24 Mar 2008 14:55 GMT
when you enter C4 you have to press the F4 button so it should become $C$4
This way it won't move when you drag.

> I need to copy a formula from column I to column J, and would like to do the
> following:
[quoted text clipped - 8 lines]
> Thank you for any help.
> Simon
 
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.