+ Reply to Thread
Results 1 to 6 of 6

I can resolve this summary of sales forecast. Please help!

  1. #1
    Registered User
    Join Date
    05-07-2021
    Location
    Belgrade
    MS-Off Ver
    2016
    Posts
    4

    I can resolve this summary of sales forecast. Please help!

    Hi,
    I have a problem solving this task. Please help!
    I hope I was able to upload an excel file to see what is not clear to me

    Create a summary of sales forecast for years 1-5, using the data below
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,324

    Re: I can resolve this summary of sales forecast. Please help!

    You don't say how much detail you need and what you mean by a Sales Forecast.

    Here's one formula that will sum the total all 5 years for the 12 month total in column N

    Add a new sheet copy the row labels and in B3 enter

    =SUM('Year 1:Year 5'!N3)

    Copy down for the totals of other rows.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-07-2021
    Location
    Belgrade
    MS-Off Ver
    2016
    Posts
    4
    The text itself says what I wrote and that is why nothing is clear to me and I cannot solve the problem. Nothing is clear to me. If you can do this task and explain to me what you did. Thanks in advance.
    Last edited by danluk12; 05-09-2021 at 10:10 AM.

  4. #4
    Registered User
    Join Date
    05-07-2021
    Location
    Belgrade
    MS-Off Ver
    2016
    Posts
    4

    Talking Re: I can resolve this summary of sales forecast. Please help!

    Thanks, I did it.

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,111

    Re: I can resolve this summary of sales forecast. Please help!

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add it for you
    https://www.msofficeforums.com/excel...st-please.html
    https://chandoo.org/forum/threads/i-...se-help.46239/

  6. #6
    Registered User
    Join Date
    05-07-2021
    Location
    Belgrade
    MS-Off Ver
    2016
    Posts
    4

    Re: I can resolve this summary of sales forecast. Please help!

    OK. Thanks. I really didn't read the rules. I'll follow the rules next time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sales Forecast
    By daniel.rausch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2015, 01:13 PM
  2. Replies: 1
    Last Post: 05-31-2014, 01:38 AM
  3. Replies: 0
    Last Post: 04-14-2014, 10:06 PM
  4. 5 year sales forecast
    By winco32 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2013, 10:09 AM
  5. Best sales forecast ever?
    By mikkelb in forum Excel General
    Replies: 0
    Last Post: 06-01-2012, 05:07 AM
  6. Sales forecast
    By kras in forum Excel General
    Replies: 2
    Last Post: 02-18-2007, 06:13 AM
  7. Replies: 4
    Last Post: 04-17-2005, 07:06 PM

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