Spill formula to sum up schedules by months

[Limor_OP]

Hello,
I have a file where I'm using SUMIF to show amounts being amortized by schedule # and month/year (tab "USD 05.22", columns L-AB)

The amounts are taken from "Amortization Schedules", column O. The schedules are filtered in column A ("USD 05.22") for all those whose date in column L ("Amortization Schedules" tab) is greater or equal to May'22 (which is the last monthly report).

Is there a way to replace the SUMIF function with a spill formula?

Thank you.

[Fluff13]

How about

Please Login or Register  to view this content.

[Limor_OP]

Thanks Fluff13! that works well of course.
Is there also a way to use dynamic formula for column B/I where I'm using XLOOKUP to search for the schedule# on "Amortization Schedules" and get columns B/P?

Thanks again!

[Fluff13]

For column G try

Please Login or Register  to view this content.

[Bo_Ry]

Please try at

B3
=XLOOKUP(A3#,'Amortization Schedules'!I2:I16886,'Amortization Schedules'!B2:B16886)

G3
=INDEX('Amortization Schedules'!A2:P16886,MATCH(A3#,'Amortization Schedules'!I2:I16886,),{5,14,16})

J3
=MMULT(L3#,TRANSPOSE(COLUMN(L3#))^0)

L42
=MMULT(TRANSPOSE(ROW(L3#))^0,L3#)

[Limor_OP]

thank you both ! I didn't know I could use XLOOKUP like that.....

[Fluff13]

Glad to help & thanks for the feedback.