Results 1 to 8 of 8

Gather values using a date range to sum up profits for a single month.

Threaded View

Walntek Gather values using a date... 09-15-2013, 03:28 PM
Ace_XL Re: Gather values using a... 09-15-2013, 03:30 PM
Walntek Re: Gather values using a... 09-15-2013, 04:08 PM
Tony Valko Re: Gather values using a... 09-15-2013, 04:13 PM
Tony Valko Re: Gather values using a... 09-15-2013, 04:22 PM
hemesh Re: Gather values using a... 09-15-2013, 03:38 PM
Walntek Re: Gather values using a... 09-15-2013, 03:48 PM
Tony Valko Re: Gather values using a... 09-15-2013, 03:58 PM
  1. #1
    Registered User
    Join Date
    09-15-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Gather values using a date range to sum up profits for a single month.

    I have been trying to figure out how to work this with sumif, sumifs and Vlookup. I have either received errors or a $0.00 value. What I am trying to do is create a function that searches sales that are within the date range mm/dd/yyyy of a single month and sum up the total profits made for that month. Here is what my table looks like:

    B.........................O......................Total profits
    9/15/13................$265.13.................September
    9/16/13................$265.13.................October
    9/17/13................$265.13.................November

    To sum up, I want to add all of the numbers in column o into my profits table when it is in the same month.
    Last edited by Walntek; 09-15-2013 at 03:30 PM.

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: 06-13-2016, 11:23 AM
  2. Replies: 4
    Last Post: 05-31-2013, 11:20 AM
  3. Array function for date(month), Range Date(month)
    By dluhut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2013, 05:14 PM
  4. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  5. Set a month as range based on single date in one cell
    By mexcel300 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2011, 10:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1