A.=AVERAGE(A1:A8)
B.=SUM(A1:A8)
C.=AVERAGE(A1,A8)
D.=SUM(A1,A8)
A.=AVERAGE(B3B9)
B.=AVERAGE(B3,B9)
C.=AVERAGE(B3/B9)
D.=AVERAGE(B3:B9)
A.=A1+A1
B.=Sheet1!A1+A1
C.=Sheet1!A1+Sheet2!A1
D.=Sheet1B1+Sheet2A1
A.=LARGE(Al:A50,3)
B.=SMALL(A1:A50,48)
C.=MIN(Al:A50,3)
D.=LARGECAl:A50,48)
A.=DATADIF(A1,TODAY(),"y")
B.=DATADIF(A1,TODAY(),"y")"周岁"
C.=DATADIF(A1,NOW(),"y")
D.=YEAR(TODAY())-YEAR(A1)
A.=LARGE(Al:A50,49)
B.=SMALL(A1:A50,2)
C.=SMALL(AI:A50,49)
D.=MAX(Al:A50,2)