asked 11.5k views
2 votes
What formula would appear if you copied and pasted the fomula

=SUM(A1:A4) from cell A5 to cell C6? ...?

1 Answer

5 votes
In MS excel, A denotes the column and the numbers denote the rows.
The colon shows the range of any cell.
Therefore,the fomula
=SUM(A1:A4)
will give you the sum of all the entries in the column A,starting from first row till the fourth row.
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.