# 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

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!

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

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!

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)?

• 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

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.

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