Explain formula

[sohaila]

Can somebody explain this formula step by step in details

View attachment 98625

Result Formula

=LET(a,Companies,b,ROWS(a),m,MAKEARRAY(b,2,LAMBDA(r,c,SUM(INDEX(C5:Z9,SEQUENCE(b),SEQUENCE(,24))*(C4:Z4=INDEX(C22:D22,c))*(a=INDEX(a,r))))),t,HSTACK(a,m),FILTER(t,INDEX(t,,3)))

 

[6StringJazzer]

Kind of hard to do without seeing row and column headings. Is the word "Month" in cell A1?

What cell is the formula in?

 

[sohaila]

Yes it is word in cell no date and Companies is range name
{"Music Motion";"Silver Leases";"Streamline Rentals";"Yogaluxe"}
range(C5:Z9)=

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

Number

Amount

and C22:D22={"Number","Amount"}

 

[sohaila]

View attachment 98679
Formula put in b23
View attachment 98678
View attachment 98676
Please help

 

[sohaila]

Green cell in formula and cell is b23