=SUM(A1:F7)
=SUM(B2:B7,D2:D7,F2:F7)
=SUM(OFFSET(A2:F7,,{1,3,5}))
=SUM(DSUM(A1:F7,{2,4,6},A1:A8))
=SUM(MMULT(IF({1,0,1},B2:D7,F2:F7),{1;1;1}))
=SUMPRODUCT(A2:F7)
=SUBTOTAL(9,A2:F7)
=SUBTOTAL(1,A2:F7)*18
=SUMIF(A1:F7,">0")
=SUMIF(A1:F7,"*",B2)
=SUMIFS(A2:F7,A2:F7,">0")
=AVERAGE(A2:F7)*18
=AVERAGEA(A2:F7)*36
=AVERAGEIF(A2:F7,">0")*18
=AVERAGEIFS(A2:F7,A2:F7,">0")*18
=AGGREGATE(1,,A2:F7)*18
=AGGREGATE(9,,A1:F7)
=NPV(0,A2:F7)
=TRIMMEAN(A2:F7,0)*18
=COUNT(1/(CHOOSE(ROUNDUP(ROW(1:18)/6,),B2:B7,LOOKUP(ROW(1:18)-6,ROW(1:10),D2:D7),LOOKUP(ROW(1:18)-12,ROW(1:18),F2:F7))>=COLUMN(1:1)))
|