i want to sum multiple cells.

Hewlett-packard / Hp pavilion tx2000 notebo...
February 28, 2010 at 07:29:15
Specs: Xp pro Sp3, 2 GHz / 1982 MB
Hi there,
First I am an experienced Noob at calc lol.
I have a grid structure of days of the week across the top, and my outgoings going down.

I simply want to add up all the cells inside this grid to tell me the total of what I must pay out that week.

Because there are about 100 odd cells with figures in, puttin the formula in 1 by 1 is a real wrist acher (A1+A2+(finishing at) +G14+G15...
I have searched and searched, but because I don't even know the name or how to do it, I can't find a simple formula to do.... "Add together cells a1 to g15"

Sorry if I don't make sense, you'll need to explain any more info you'd need lol.

See More: i want to sum multiple cells.

Report •

February 28, 2010 at 07:40:49
There are a number of ways to write a formula using the SUM function.

For a simplistic explanation, look up SUM in the Excel Help files and review the info, especially the examples at the bottom.

Then, if Add Numbers doesn't appear as choice when you search for Sum in Help, search for Add Numbers for lots of detailed information.

And please, please...don't included multiple "lol's" in your posts.


My error...I didn't notice that you were using Calc.

In any case, as Mike says below, SUM is the function you need and reading the Help files is usually the best place to start.

Report •

February 28, 2010 at 07:50:00
The SUM function in Calc will be listed under Mathematical Functions in the help files.
Do a Find on the word sum and select
Mathematical Functions from the list.
You'll have to scroll down about 3/4 of a page.
There are several other SUM functions listed, you want plain old unadorned SUM.
Calc is almost the same as Excel so most of the formulas you use in one you can use in the other.



Report •

February 28, 2010 at 08:41:20
Thank you for speedy reply, and suggestion.
The help files were confusing for me to understand, but after about the 4th read of the sum function, it clicked that I didn't put the "=" before the sum. Just goes to show how we "look" at words instead of reading them.
I shall endeavour to refrain from using lol's in future posts, it's a social habit hard to break lo.... almost!

Anyway thanks again, You've saved me from wrist ache.

Report •

Related Solutions

February 28, 2010 at 09:01:37
All formulae must start with an = sign.

That's what tells Calc and Excel that it is a formula.

Otherwise, the application assumes that the entry is just text or a date or a number.

Report •

Ask Question