SUM monthly total of each employee from separate weekly table

[kirkley08]

Hi, I'm wondering if there is any easy way using excel formula to sum each employee's correct and error (yellow area) monthly from each separate weekly table.
For now Im using =sum(xx,xx,xx) to total them, just wondering if there is any other way. Thank you!

 

[hagia_sofia]

Hello, please test the following, not a very elegant formula (you will need to adjust ranges):

=LET(
month,10,
year,2024,
from,$B$1:$B$33,
to,$E$1:$E$33,
names,$A$1:$A$33,
name,$H3,
data,B$1:B$33,
dates,$D$1:$D$33,
b_f,FILTER(from,dates="to"),
c_f,b_f+SEQUENCE(,ROWS(from)/ROWS(b_f),0,0),
d_f,FILTERXML("<x><y>"&SUBSTITUTE(TEXTJOIN(",",,TRANSPOSE(c_f)),",","</y><y>")&"</y></x>","//y"),
e_f,SORT(d_f),
b_t,FILTER(to,dates="to"),
c_t,b_t+SEQUENCE(,ROWS(to)/ROWS(b_t),0,0),
d_t,FILTERXML("<x><y>"&SUBSTITUTE(TEXTJOIN(",",,TRANSPOSE(c_t)),",","</y><y>")&"</y></x>","//y"),
e_t,SORT(d_t),
SUM(FILTER(data,(names=name)*((MONTH(e_f)=month)+(MONTH(e_t)=month))*((YEAR(e_f)=year)+(YEAR(e_t)=year)))))