+ Reply to Thread
Results 1 to 3 of 3

Creating a projections spreadsheet with quarterly totals in the columns

  1. #1
    Registered User
    Join Date
    07-28-2005
    Posts
    10

    Red face Creating a projections spreadsheet with quarterly totals in the columns

    I would like to calculate my revenue growth with a simple percentage of the prior months revenue (=C10*0.2+C10) across a 12 month basis. However, I calculate totals on a quarterly basis. I would like to have my formula skip my quarterly total columns.. in this case F, J, N so that I can drag my formula across 12 months and not have my quarterly totals effected. Is this possible and how?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Creating a projections spreadsheet with quarterly totals in the columns

    Please post the workbook

  3. #3
    Registered User
    Join Date
    04-20-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2013, 2010, 2007, 2003
    Posts
    99

    Re: Creating a projections spreadsheet with quarterly totals in the columns

    Assuming you're starting point is column A (January) you would then have

    A-Jan
    B-Feb
    C-Mar
    D-Blank
    E-April

    To fill across, input your formula in B,C, and E, highlight these 4 cells, and drag across.
    Once you're done with that you can tell me how you're acheiving 20% month over month growth
    SPARTAN
    Please click the * if my solution helped

+ Reply to Thread

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