Question

23. i want to add cells value from c5 to c70, and show output of this addition in cell a3. Which formula should i use?

Answer 1

Answer:

SUM(C5 : C70)

Step-by-step explanation:

The SUM function returns with the value of the addition of the cells whose range is given in the bracket.

I hope this answer helps you

Answer 2

Answer:

=SUM(c5:c70)

Step-by-step explanation:

I hope u r talking about microsoft excel sheet.

There to add the cell values from c3 to c70 one can simply drag the cella down, but that will not add the sums in the cell a3 but in c71.

So we've to use the predefined formulae in the application itself.

i) Go to the cell a3.

ii) Put the sign '=' ; it'll activate the functions.

ii) Write 'SUM' after '=' ; it identifies the specific function we;re going to use.

iii) Place a '(' then go to the cell c3.

iv) Place a ':' and then go to the cell c70.

v) Press enter.