writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 79:
Line 79: + + + +
no edit summary
=SUBTOTAL(9,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using SUM function. Returns '''209''' as a result.
=SUBTOTAL(9,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using SUM function. Returns '''209''' as a result.
=SUBTOTAL(1,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using AVERAGE function. Returns '''34.833333333333336''' as a result.
=SUBTOTAL(1,A1:A6) : Calculates the subtotal of numbers in the range A1 to A6 using AVERAGE function. Returns '''34.833333333333336''' as a result.
==Related Videos==
{{#ev:youtube|H_cHbbVwvPQ|280|center|SUBTOTAL}}
==See Also==
==See Also==