Results 1 to 4 of 4

how to 'paste' formula in multiple lines with keeping part of formula constant

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    brunswick maine
    MS-Off Ver
    Excel 2007
    Posts
    1

    how to 'paste' formula in multiple lines with keeping part of formula constant

    thanks in advance.
    i have essentially a receipt spreadsheet (E2007) where i multiply cost [different prices by column](E3, etc) by quantity [differnent numbers by column](E4, etc) and sums total into O4. i am breaking each day down by customer, so would like to copy my formula, but the cost row will be constant. when i copy/paste into subsequent rows, the formula updates each function line item.
    ie what was the value of O21:
    =SUM(F21*F51, G21*G51, H21*H51, I21* I51,J21*J51,K21*K51, L21*L51,M21*M51)
    becomes for row O22:
    =SUM(F22*F52, G22*G52, H22*H52, I22* I52,J22*J52,K22*K52, L22*L52,M22*M52)
    but what i want for row O22 thru indefinate rows, is:
    =SUM(F21*F52, G21*G52, H21*H52, I21* I52,J21*J52,K21*K52, L21*L52,M21*M52)
    without having to retype at each row.
    i am open to an easier formula, than what i currently have, for the total cost too!
    i hope thats all clear!

    [I]well, never being so silly as to refuse help...here's a sample. you all are great for replying so quickly! your suggestions are so helpful, feel free to keep 'em coming![I]
    Attached Files Attached Files
    Last edited by ddsdms; 09-26-2012 at 04:40 PM. Reason: reference spreadsheet

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