食材準備與總數量 (15238)

日期：

L2:L8{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(L$1:L1,C$2:I$8)=0)*(LEFT(C$1:I$1,2)="食材")*(C$2:I$8<>""),ROW($2:$8)/1%+COLUMN(C:I))),"!R0C00"),),"")

M2:M8=IF(L2="","",SUMPRODUCT(MMULT((C$2:I$8=L2)*N(+D$2:J$8),ROW(1:7)^0)*B$2:B$8))



留言

  1. 匿名2026年8月4日 凌晨1:27

    =LET(
    a, B2:B8, b, C2:J8,
    v, DROP(REDUCE("", SEQUENCE(, COLUMNS(b)/ 2,, 2), LAMBDA(x,y, VSTACK(x,
    HSTACK(INDEX(b, SEQUENCE(ROWS(b)), SEQUENCE(,2, y)), a)))), 1),
    q, FILTER(v, TAKE(v,, 1) <> 0),
    f, LAMBDA(e, CHOOSECOLS(q, e)),
    h, HSTACK(q, f(2) * f(3)),
    k, LAMBDA(s, TAKE(h,, s)),
    GROUPBY(k(1), k(-1), SUM, 0,0))

    回覆刪除

張貼留言