Hewlett-packard / Hp pavilion tx2000 notebo...

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.

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.

Edit: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.

The SUMfunction in Calc will be listed under Mathematical Functions in the help files.

Do aFindon the wordsumand 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.MIKE

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.

Allformulae 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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History