XOR LX... Much simpler than mine (which was considerably more involved). However, I think that this modification is useful...

=SUMIFS(INDEX(F!$1:$1048576,MATCH(OFFSET($K$1,INT((ROW()-2)/34)*34,0),F!A:A,0)+1,),F!$3:$3,G!A70)