+ Reply to Thread
Results 1 to 4 of 4

adding up numbers based upon same date

  1. #1
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    142

    adding up numbers based upon same date

    I need some help in calculating daily profits (the last day daily profits).

    In Q1 I'd like it to add the contents of column Q until the dates change.

    The last day of profits is 3/22/18 and the profits are $1,635.05.

    Thanks.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: adding up numbers based upon same date

    So you are looking for a formula to sum the numbers in column Q that correspond to the last day of entries?

    If so, try this:

    =SUMIF(C6:C34,LOOKUP(2,1/(E6:E34<>""),C7:C35),Q6:Q34)

    It returns 1653.05

  3. #3
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    142

    Re: adding up numbers based upon same date

    Perfect.

    My XLS is exactly how I want it.

    Thanks.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: adding up numbers based upon same date

    You're welcome. Thanks for the rep!

+ 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. [SOLVED] Adding numbers based on the value of a number in the middle of the cell
    By Chris McGlothen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2018, 05:03 PM
  2. Coloring cells based on date range and adding a shape at a certain date
    By moomphas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2018, 05:17 AM
  3. adding numbers from different fields to date
    By ajitexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2017, 10:59 AM
  4. Formula for adding numbers based on month
    By wonderd in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-04-2015, 09:46 PM
  5. Adding up a row of numbers until they are > than a cell and then return adjacent date
    By thunderbirdlindy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2014, 06:09 PM
  6. Displaying or adding numbers based on flag
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 03:56 PM
  7. [SOLVED] Adding Week Numbers with date Functions
    By huston1679 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2009, 11:16 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