How batch calculations?

[Guest]

Hello all:

EXCEL has the function to input calculation results. Say A2=2, B2=3. If we
want to input C2 with A2+B2, then we just, with cursor on C2, need to do:
=A2+B2. The result 5 will input to C2.

Now my question is how to do batch calculation? Say:
A2=2, A3=3, A4=4, ....., An=n, .....
B2=4, B3=6, B4=8, ......, Bn=2n, ....
I want the C column is the summary of A column and B column:
C2=A2+B2, C3=A3+B3, C4=A4+B4, ....., Cn=An+Bn, .....

Because A and B columns are very long, it is too trouble to calculate one
by one.
What is the way to CALCULATE THEM IN A BATCH, just one step to calculate all
of them?

Thank you in advance!

 

[kk]

Hi

Try use SUM()

Example: =SUM(A2:B1000)


Hello all:

EXCEL has the function to input calculation results. Say A2=2, B2=3. If we
want to input C2 with A2+B2, then we just, with cursor on C2, need to do:
=A2+B2. The result 5 will input to C2.

Now my question is how to do batch calculation? Say:
A2=2, A3=3, A4=4, ....., An=n, .....
B2=4, B3=6, B4=8, ......, Bn=2n, ....
I want the C column is the summary of A column and B column:
C2=A2+B2, C3=A3+B3, C4=A4+B4, ....., Cn=An+Bn, .....

Because A and B columns are very long, it is too trouble to calculate one
by one.
What is the way to CALCULATE THEM IN A BATCH, just one step to calculate all
of them?

Thank you in advance!

 

[Rowan]

In C2 enter =A2+B2. You can then just copy this formula down to the rest
of your rows either by using copy and paste or the fill handle. The fill
handler is the black square that appears on the botton right hand corner
of the selected cell. If you hover your mouse over this it will turn
into a cross. You can then click and drag down and it will copy your
formula down as far as you drag. You can also double click the fill
handle which will automatically copy the formula down to the end of your
data.

Hope this helps
Rowan