# worksheet sum

## Recommended Posts

Hi

What is the syntax for summing a bunch of cells? Say I have numbers in B3, H4 and J8 for example. I can't do =SUM(B3+H4+J8), so what is the correct way?

Thank you

##### Link to comment

If you just want a few cells you don't need the sum you can just add them up:   =B3+H4+J8

If you have a larger range you can specify the range by using two periods between the beginning and end of the range plus a Sum:    =SUM(A3..D3)

If you have a discontinuous (or continuous) range you can also use a comma as a separator in a Sum:    =SUM(B3, H4, J8)

Or you can combine the two styles:    =SUM(A3..D3, H8)

HTH

thank you!

##### Link to comment
• 1 year later...

I can't really understand why they don't stick to the Excel standard, I need to google this all the time.

##### Link to comment
On 5/4/2022 at 4:00 PM, MartinBlomberg said:

I can't really understand why they don't stick to the Excel standard, I need to google this all the time.

could not agree more!

##### Link to comment

Do you realize that the VW worksheet is actually OLDER than Excel? So why didn't Excel adopt the VW standard (which I think was actually the Visicalc standard)?

##### Link to comment
• 3 weeks later...
On 5/8/2022 at 9:39 PM, Pat Stanford said:

Do you realize that the VW worksheet is actually OLDER than Excel? So why didn't Excel adopt the VW standard (which I think was actually the Visicalc standard)?

Cosmic coincidence I was just watching this

##### Link to comment
On 5/5/2022 at 2:00 AM, MartinBlomberg said:

I can't really understand why they don't stick to the Excel standard, I need to google this all the time.

Also VWs worksheet is so undocumented, sometimes things that should work just don't. I've got a long text file of solutions from working with it since ~2006.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×

• KBASE
• #### MARIONETTE

×
• Create New...