Results 1 to 4 of 4

How can I copy a formula to new rows so that some values remain constant?

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    Hastings, UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    How can I copy a formula to new rows so that some values remain constant?

    I have used the following long but simple formula.

    =SUM((B17*B14)+(C17*C14)+(D17*D14)+(E17*E14)+(F17*F14)+(G17*G14)+(H17*H14)+(I17*I14)+(J17*J14)+(K17*K14)+(L17*L14)+(M17*M14)+(N17*N14)+(O17*O14))

    I need to copy it to numerous other cells. However I need the row fourteen values to remain the same while the other values change according to which row I'm copying it to e.g

    =SUM((B20*B14)+(C20*C14)+(D20*D14)+(E20*E14)+(F20*F14)+(G20*G14)+(H20*H14)+(I20*I14)+(J20*J14)+(K20*K14)+(L20*L14)+(M20*M14)+(N20*N14)+(O20*O14))

    Is there any way of doing this without changing the formula manually every time?
    Last edited by jpjonnyjp; 02-26-2009 at 06:47 AM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1