Excel has a built in sum function to calculate the sum of elements. The syntax of this function is:
=sum(argument)
This formula is written in the destination cell where we need our sum to show up.
The argument is the cells , columns or range of cells and columns for which we need to find the sum. If we need to find the sum of elements in a column, the formula will be like:
= sum(A:A)
This formula will find the sum of all elements that are present in the column A. The argument in the above formula is A:A which represents that entire column A is selected.
This formula can be modified according to the needs. For example, if we need to find the sum of two columns A and B, the formula will be:
=sum(A:B)
This formula calculates the sum of all elements in columns A and B.