|
【作业一】求C11单元格各数字之和(C11数字为任意正整数)- =SUM(LEFT(C11,1),MID(C11,2,1),MID(C11,3,1),MID(C11,4,1),MID(C11,5,1),RIGHT(C11,1))
复制代码 --------------------------------------------------------------------------------------------------------------------------------------------
【作业二】提取C16:C17单元格是的汉字(汉字为连续出现)- =LEFT(C16,LENB(C16)-LEN(C16))
复制代码- =RIGHT(C17,LENB(C17)-LEN(C17))
复制代码 -----------------------------------------------------------------------------------------------------------------------------------------------
【作业三】统计本月一共有多少天(至少二种以上不同方法)- =DAY(DATE(YEAR(A22),MONTH(A22)+1,0))
复制代码- =DATE(YEAR(A22),MONTH(A22)+1,1)-DATE(YEAR(A22),MONTH(A22),1)
复制代码 -----------------------------------------------------------------------------------------------------------------------------------------------
【作业四】统计表1中销售员为某人时本月的销售额,主要是区分大小字(用至少3种方法)- =SUMPRODUCT(EXACT(A27,B33:B62)*C33:C62)
复制代码- =SUM((CODE(A27)=CODE(B33:B62))*C33:C62)
复制代码- =SUM((FIND(A27,B33:B62&A27)=1)*C33:C62)
复制代码 以上三种均Ctrl+Shift+Enter三键结束
----------------------------------------------------------------------------------------------------------------------------------------------------
【作业五】在表1中,按星期一至星期天统计本月的销售额,G36公式下拉(最好只引用A36:B65区域,其它用ROW等函数时的参数不计)- =SUMPRODUCT((WEEKDAY($A$33:$A$62,2)=F33)*$C$33:$C$62)
复制代码 向下填充至H39单元格即可
----------------------------------------------------------------------------------------------------------------------------------------------------
【函初201203班]- B33-Laphe
|
评分
-
查看全部评分
|