+ Reply to Thread
Results 1 to 6 of 6

How can I add monthly sales data? Using formula?

  1. #1
    Registered User
    Join Date
    09-29-2013
    Location
    LA
    MS-Off Ver
    Excel 2008
    Posts
    83

    Exclamation How can I add monthly sales data? Using formula?

    How can I add data to the monthly sales section in the workbook? I can't seem to figure out the code.

    mockup.xlsx

  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
    29,464

    Re: How can I add monthly sales data? Using formula?

    Hi

    Put proper date numbers in H28:J28, i.e. 10/1/2013, 11/1/2013, 12/1/2013 (format them however you like)

    H29 copied across and down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-29-2013
    Location
    LA
    MS-Off Ver
    Excel 2008
    Posts
    83

    Re: How can I add monthly sales data? Using formula?

    It seems like I am not entering the code correctly/ The results fill as 1/1 instead of actual sales data.

    mockup.xlsx

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How can I add monthly sales data? Using formula?

    Richard said real dates in h28:j28 ie the first of each month then format those cells as mmmm to show October November December
    you seem to have formatted the cells with the formulas as date m/d change the format of those back to currency
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    09-29-2013
    Location
    LA
    MS-Off Ver
    Excel 2008
    Posts
    83

    Re: How can I add monthly sales data? Using formula?

    thank you. How do you mark thread as solved?

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How can I add monthly sales data? Using formula?

    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

+ 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. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  2. Replies: 7
    Last Post: 07-23-2013, 07:56 AM
  3. Replies: 4
    Last Post: 03-27-2013, 05:56 PM
  4. Replies: 2
    Last Post: 06-19-2012, 10:19 AM
  5. [SOLVED] Formula help in a monthly sales report.
    By chevyman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-13-2005, 12:06 PM

Tags for this Thread

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