Need help with an IF Statement that refrences dates and values

Closed
Report
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
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.


1 reply

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
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")