Taking a real stab in the dark here. I added two helper columns that populate with formulas. The first helper column (G) will return a value if the participant is 15 or younger and the j4_core is 1 (which I assume to be true) using the formula:
=IF(AND(B2<=15,C2=1),1,"")
The second helper column will return a value only the participant had a poverty value of 1 at age 26 and a j4_core value of 1 at the age of 15 or younger using the formula:
=IF(AND(B2=26,D2=1,SUMPRODUCT(($A$2:$A$11085=A2)*($G$2:$G$11085=1))>0),1,"")
I added a table in L1:M3 that shows the total participants in poverty at age 26 and those that were j4_core at age 15 or younger. The latter is calculated by summing column H. Here is a copy of your file with the helper columns and formulas applied: Copy of MOCKUP WKBK.xlsx
One thing you may want to consider is what do you do in the cases where there is no data on the subject at age 26, such as participant A00018?
Let me know if you have any questions.
Bookmarks