+ Reply to Thread
Results 1 to 6 of 6

Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than 365

  1. #1
    Registered User
    Join Date
    09-16-2020
    Location
    United States
    MS-Off Ver
    365
    Posts
    3

    Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than 365

    I am trying to build a formula that sums a column of shares owned based on the date in which the shares were purchased. I need the formula to subtract the date the shares were purchased from today's date and if that is greater or equal to 365, add the corresponding number of shares purchased. My current formula is... =SUMPRODUCT(SUMIF(B3:B32,TODAY()-B3:B34&">="&365,H3:H32))... however it is reading zero even though there are 18 dates that qualify. Thanks in advance for the help!
    Attached Files Attached Files
    Last edited by jrs23; 09-16-2020 at 05:02 PM.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    1,215

    Re: Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than

    Hi,
    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    09-16-2020
    Location
    United States
    MS-Off Ver
    365
    Posts
    3

    Re: Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than

    Hi. I uploaded an attachment. Thanks!

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010/office 365
    Posts
    1,215

    Re: Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than

    =sumproduct((today()-b3:b7>=365)*($c$3:$c$7))

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    775

    Re: Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than

    E3=sumifs(c3:c7,b3:b7,"<="&edate(today(),-12))

  6. #6
    Registered User
    Join Date
    09-16-2020
    Location
    United States
    MS-Off Ver
    365
    Posts
    3

    Re: Sumif embedded in a sumproduct w/ today's date minus a column of dates is greater than

    It worked! Thanks for the help.

+ 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] Formula to calculate progress between two dates with start date greater than today
    By valeriemt2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2020, 11:22 AM
  2. [SOLVED] DATE minus TODAY formula
    By Kagesen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2018, 01:53 AM
  3. [SOLVED] Sumif from date (Today or greater than today) to last date
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2015, 03:53 AM
  4. Autofill Date with =Today() function minus weekends.
    By slkenda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2013, 02:09 AM
  5. [SOLVED] If Statement with today's date minus due date for a delay calculation
    By RDFUC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 02:58 PM
  6. [SOLVED] Macros for: If Today's Date minus other date is greater than certain amount of days Then
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-24-2012, 04:46 PM
  7. Today's date minus two
    By mldardy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2011, 11:51 AM

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