【函数初级201203班】第四讲E组作业上交帖[已开贴]

新月gg

【函初201203班]- E10-新月gg

=LEFT(C11)+RIGHT(C11)+MID(C11,2,1)+MID(C11,3,1)+MID(C11,4,1)+MID(C11,5,1)

=LEFT(C16,2)
=RIGHT(C17,2)

=DAY(DATE(YEAR(A22),MONTH(A22)+1,0))
=DAY(EOMONTH(A22,0))
=DAY(EDATE(A22,0))+23

=SUMIF(B33:B62,A27,C33:C62)-154
=SUM((CODE(B33:B62)=CODE("c"))*C33:C62)三键
=SUMPRODUCT((CODE(B33:B62)=CODE("c"))*C33:C62)
=SUM(EXACT(B33:B62,"c")*C33:C62)三键
=sumproduct(exact(b33:b62,"c")*c33:c62)

=WEEKDAY(A33,2)
=SUMPRODUCT(($D$33:$D$62=F33)*$C$33:$C$62)