I have a data set which shows test results, each person my have several rows of data. My labels are
ID - Test Date - Test Result - Interval Between Tests
I want to sum the interval between tests for entries with the same ID, and return the test result when the interval sum is 365 days.
I have used =SUMIF(Sheet1!A:A,"="&VLOOKUP(Sheet2!A17, Sheet1!A2:K62,1,FALSE),Sheet1!K:K)
to sum all the interval days between tests for each individual but I want to know which test occur 365 days from the first test. Any ideas?