180k views
3 votes
Which function can you use to abbreviate the lengthy expression, A1+A2+A3+A3...+A19+A20?  MAX COUNT SUM ROUND

User Looloobs
by
8.1k points

1 Answer

3 votes

Answer:

SUM

Step-by-step explanation:

The lengthy expression, A1 + A2 + A3 + A4 + ... + A19 + A20 can be abbreviated with the function SUM. In this case, the expression is: SUM(A1:A20). As can be seen with this example, this function returns the sum of the range of cells.

User Knorthfield
by
8.8k points