Is it possible to nest filter inside of sumif?

Hi papa_austin 

Thanks for providing a sample + expected result. Decomposed this could be something like:

=LET(
    h,  (Table1[#Headers]=B24) + (Table1[#Headers]=C24) + (Table1[#Headers]="Year"),
    f,  FILTER( FILTER(Table1,Table1[Text1]=B23), h),
    y,  INDEX(f,,1),
    s,  SEQUENCE(,COLUMNS(f)-1,2),
    v,  INDEX(f,SEQUENCE(ROWS(f)),s),
    t,  MMULT(v, SEQUENCE(COLUMNS(v))^0),
    CHOOSE({1;2}, y, t)
)

This is implemented in the attached file

I would highly recommend you refer to Excel 365 SUM dynamic array at row level where you'll find different approaches to this and other calcs