Adding multiple cells at once.

[bluewaves]

Hello,

Do you know how to add multiple cells at one time? Example: I have 10 consecutive rows of numbers. How do I get a sum total of all of those cells by selecting them all instead of adding each one individually?

Awaiting your reply...

[MarvinP]

Hi bluewaves and welcome to the forum,

If you look at the icons on the excel toolbar you will find a Sigma character. That looks like a capital letter E with a greek slant. If you put your cursor at the bottom of the 10 numbers and then click on that Sigma icon it will ask if you want the Sum, Count or a few other kinds of totals.

Is that what you wanted to know?

Here are a few links to study also.
http://www.ozgrid.com/Excel/autosum.htm
http://gaetc-ejournal.org/tutorials/...values/sum.htm where this page shows what I meant.

[ConneXionLost]

If you mean "add" as an arithmetic operation, then you can refer to a range when using the SUM function like this:

Please Login or Register  to view this content.

Cheers,

[HSV]

Do you mean this?

example: =SUM(A1:C10)

Type; =SUM( then select all cells, and then ) and press Enter.

[martindwilson]

or just right click the very bottom bar of the excel window select sum
select cells you want and the total will show on that bar

[bluewaves]

Hi bluewaves and welcome to the forum,

If you look at the icons on the excel toolbar you will find a Sigma character. That looks like a capital letter E with a greek slant. If you put your cursor at the bottom of the 10 numbers and then click on that Sigma icon it will ask if you want the Sum, Count or a few other kinds of totals.

Is that what you wanted to know?

Here are a few links to study also.
http://www.ozgrid.com/Excel/autosum.htm
http://gaetc-ejournal.org/tutorials/...values/sum.htm where this page shows what I meant.

Yes! Thank you and everyone else for your replies.