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
Related:
- Need help with an IF Statement that refrences dates and values
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
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")
