Need help with an IF Statement that refrences dates and values
Closed
zacharywsullivan
-
Aug 4, 2016 at 03:08 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 6, 2016 at 07:15 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 6, 2016 at 07:15 PM
Hello,
I have a spreadsheet that has a bunch of maturity dates and corresponding return values. What I need to do is create an if statement that says "if the maturity date =2018, then add all the return values for that corresponding year". Thanks.
I have a spreadsheet that has a bunch of maturity dates and corresponding return values. What I need to do is create an if statement that says "if the maturity date =2018, then add all the return values for that corresponding year". Thanks.
Related:
- Need help with an IF Statement that refrences dates and values
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- Using nested if to blank out adjacent cells - Excel Forum
- If function with dates - Guide
1 response
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Aug 6, 2016 at 07:15 PM
Aug 6, 2016 at 07:15 PM
You don't give much detail regarding what your data looks like :(
2 different approaches come to mind...
1. create a helper column to extract the year from your date, then use SUMIF() based on that column
2. Use SUMPROUCT()
hmm a 3rd option would be to use SUMIFS(sum-range, date-range, ">=11//2016",date-range, "<1/1/2019")
2 different approaches come to mind...
1. create a helper column to extract the year from your date, then use SUMIF() based on that column
2. Use SUMPROUCT()
hmm a 3rd option would be to use SUMIFS(sum-range, date-range, ">=11//2016",date-range, "<1/1/2019")
