Asked in
Microsoft Excel

The auto Sum function is used to create a formula that includes a range of cells?

Answer

User Avatar
Wiki User
February 23, 2013 4:42PM

Yes, that is its main function. It can also add individual cells or values or the results of other functions. Here are various examples:

=SUM(A2:A20)

=SUM(A2,A6,122,A30,B16,20,25)

=SUM(MAX(A2:A20),MAX(B2:B20))