another (basic I hope) fomula question....please help!

[winchester369]

I asked a formula question a few days ago, and got quick and accurate help, so thank you...
but now I have another question.....

I want all numbers in one column to add up to a total at the bottom... A friend says I have to use something like "=k3+k4+k5+k6....etc. etc..." in the "total" cell, stating every number... But I have over 200 numbers in that column....

Is there an easier formula?

Thanks

Dwayne

 

[PaddyD]

Hi - try this:


1) select a cell underneath the column of data you want to sum
2) hold down the ALT key & press =
3) Press enter.


Paddy

 

[winchester369]

Thank you for the quick response.... I did just that, and it says "=sum()"....asking for each individual number to be placed in the perenthese...

Dwayne

 

[NCay]

=sum(k1:k999) will add cells k1 to k999. hope this helps

 

[winchester369]

EUREKA!!!!!!!

That did it!


Thanks so much!!!!!!

 

[winchester369]

Again...I apologize for asking such elementary questions... I am just now using excel for the first time, and pulling all my hairs out!!!


Thanks so much for your time.

 

[PaddyD]

Never appologise for asking a question - no one was born knowing how excel works

Re my initial suggestion - it will only work if the cell you are using is in the same column (or row) as the range of cells you want to sum.

Paddy

 

[winchester369]

Hopefully, I will get this mastered, if that is even possible without being a mathematical genius...LOL

but I thank you all, your help is greatly apreciated.

Dwayne

 

[RichardS]

You could also use the Autosum button on the toolbar.

Richard

 

[NCay]

paddy's right. we are all here to learn from each other, and although you may not believe it now- you too may one day be solving these sort of queries for other newbie excel users.