A组20号魔魔作业:
1、- =MMULT(ISNUMBER(FIND(TRANSPOSE(A7:A19),D7:D9))*TRANSPOSE(B7:B19),ROW(1:13)^0)
复制代码 2、- =MMULT(TRANSPOSE(MONTH(收支表!A2:A500)=MONTH(B24))*(TRANSPOSE(收支表!B2:B500)=A27:A34),(收支表!C2:C500=B26:F26)*收支表!D2:D500)
- =MMULT(TRANSPOSE(MONTH(收支表!A2:A500)=MONTH(B24))*(TRANSPOSE(收支表!B2:B500)=A27:A34),(收支表!C2:C500=B26:F26)*收支表!E2:E500)
复制代码 3、- =MMULT(TRANSPOSE((C40:C48%<{1,2,9}*10)*(C40:C48%>={0,1,2}*10)),(B40:B48%%<{1,2,9})*(B40:B48%%>={0,1,2}))
复制代码 |