+ Reply to Thread
Results 1 to 3 of 3

How to copy and paste a SUMIF formula with slight alterations to the formula?

  1. 09-16-2014, 06:44 AM #1
    Dododo
    Dododo is offline
    Registered User
    Join Date
    09-16-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 14.4.3 Mac
    Posts
    1

    How to copy and paste a SUMIF formula with slight alterations to the formula?

    Hi Excel Forum!
    First time poster, I was wondering if you guys would mind lending me your excel expertise for an issue I'm having making a finance tracker. I have sorted out most of what I need, except for a summary page I am working on. Each month is in a separate spreadsheet, and they are broken down into fortnightly lots.

    What I need exactly, is a way to copy/paste a column of formulas that look like "=SUMIF('September 1'!B39:B138, "=Shopping",'September 1'!D39:D138"
    into a new column, but with the "B39:B138" to "I39:I138" and a similar alteration for the "D39 etc" portion of the formula... At some point I will also need to know how to alter the formulate but only changing the "September" part to another month.

    Would appreciate any idea in saving some time here! I have never really been taught how to Excel but it is providing invaluable for this task! I just need some help please!?

    Cheers,
    Isaac
    Reply With QuoteRegister To Reply
  2. 09-16-2014, 10:13 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to copy and paste a SUMIF formula with slight alterations to the formula?

    Hi, welcome to the forum

    It might help if you provided a (clean) small sample workbook of what you are trying to do. For instance, if you are copying that 7 columns over, then just copy it, but if you are only copying that 1 column over, then maybe we need to look at a different option?

    Also, unless you have a category called =shopping (including the =) then I have a feeling that is not going to work
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 09-16-2014, 10:14 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: How to copy and paste a SUMIF formula with slight alterations to the formula?

    deleted forum-induced duplicate post
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy template, rename it and makes som code alterations automatically
    By yusaef in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2014, 01:20 PM
  2. Slight modification to copy paste loop
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-19-2010, 04:09 PM
  3. Slight adjustment to this formula
    By RunHard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2009, 04:32 PM
  4. Concatenate Question - How do I copy and paste the formula's result - not the formula
    By Rokketman in forum Excel General
    Replies: 1
    Last Post: 05-20-2009, 08:15 AM
  5. Concatenate Question - How do I copy and paste the formula's result - not the formula
    By Rokketman in forum Excel General
    Replies: 1
    Last Post: 05-20-2009, 07:56 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1