Hi all, apologies if there is an answer to something along these lines already, but I have extensively searched and I can't find anything to apply to this issue.
I have a formula that works the way I want it to, however I want to apply similar formulas to 2 tables which need independent filters (therefore formatted as a table) - when I convert to a table the formula no longer works.
What I am trying to do is keep track of attendance, so dynamic dates and I want it filtered by the year of birth of the participant and counting the "Yes" in the appropriate column:
This is the screenshot oof what I have
The formulas in J2 worked pre formatting as table, and that formula is:
=SUMPRODUCT(($C$1:$F$16="Yes")*($C$1:$F$1=$K$2)*($A$1:$A$16=H2))
However if I try change this to table format of:
=SUMPRODUCT((Table2[[#All],[08/10/2022]:[17/09/2022]]="Yes")*(Table2[[#Headers],[08/10/2022]:[17/09/2022]]=$K$2)*(Table2[[#All],[Year Born]]=H2))
I then get a result of 0
Any help much appreciated!
Thanks,
N
I have a formula that works the way I want it to, however I want to apply similar formulas to 2 tables which need independent filters (therefore formatted as a table) - when I convert to a table the formula no longer works.
What I am trying to do is keep track of attendance, so dynamic dates and I want it filtered by the year of birth of the participant and counting the "Yes" in the appropriate column:
This is the screenshot oof what I have
The formulas in J2 worked pre formatting as table, and that formula is:
=SUMPRODUCT(($C$1:$F$16="Yes")*($C$1:$F$1=$K$2)*($A$1:$A$16=H2))
However if I try change this to table format of:
=SUMPRODUCT((Table2[[#All],[08/10/2022]:[17/09/2022]]="Yes")*(Table2[[#Headers],[08/10/2022]:[17/09/2022]]=$K$2)*(Table2[[#All],[Year Born]]=H2))
I then get a result of 0
Any help much appreciated!
Thanks,
N