Jump to content

worksheet sum


Recommended Posts

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

  • Like 3
Link to comment
  • 1 year later...
  • 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

 

  

  

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

Link to comment
  • 9 months 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)?

Had no clue, nice to know 😃

So, how do I make these numbers add upp? All I get is "12". The line names are "2.1, 2.2, 2.3" and so on.... 

Thanks!

image.png.2d7eaddcea9850f144c4d252a3326259.png

Edited by MartinBlomberg
Link to comment
56 minutes ago, MartinBlomberg said:

Had no clue, nice to know 😃

So, how do I make these numbers add upp? All I get is "12". The line names are "2.1, 2.2, 2.3" and so on.... 

Thanks!

image.png.2d7eaddcea9850f144c4d252a3326259.png

 

I think the fact you have a 12 in the column header indicates the values are text rather than numbers or integers. If the data type was number or integer the values would be summed in the header + it would just be a matter of entering =D2 in a cell to show the total

Link to comment
46 minutes ago, Tom W. said:

 

I think the fact you have a 12 in the column header indicates the values are text rather than numbers or integers. If the data type was number or integer the values would be summed in the header + it would just be a matter of entering =D2 in a cell to show the total

Thanks! So instead of using the SUM-function, I'll just use "=D2". Did I get that right?

Link to comment
7 minutes ago, MartinBlomberg said:

Thanks! So instead of using the SUM-function, I'll just use "=D2". Did I get that right?

 

It's not the formula that's the problem is the data. Where is it coming from? These are Amps from a record format right? I think you need to edit the record + change the data type for that field from text to integer. Then it will show the summed value in D2. I think.

  • Like 2
Link to comment

Another thing to try is to use the Worksheet Format menu and format cell D2 (which will then flow down to all the subrows) as a number instead of as text. That MIGHT solve the problem.

 

VW (and basically every other program) has the ability to store data as either numbers or as a string of characters. If the values are a string of characters, say 1 6 5 3, then out brains automatically "see" a number 1653. But the program does not know that unless you specifically tell it to do so.

 

If you know the data in that field will never contain anything except digits, you could also use a formula of =Value(whatever formula you already had in D2). The Value function converts a character string that represents a number into the numeric value.  But if someone enters the value as 16 Amps instead of just 16, the value function will break.

 

So back to @Tom W.'s statement, it is not a formula problem, it is a data problem.

 

And once you get the correct values into the column, then yes, all you need to do to access the automatically summed value somewhere else in the worksheet is is a formula of =D2.

 

HTH

  • Like 2
Link to comment
On 3/20/2023 at 4:34 PM, Tom W. said:

 

It's not the formula that's the problem is the data. Where is it coming from? These are Amps from a record format right? I think you need to edit the record + change the data type for that field from text to integer. Then it will show the summed value in D2. I think.

Thanks! You're right @Tom W., the information I use comes from a record. I use Pop-up as function. Isn't it possible to use popup with a sum-function?

 

@Pat Stanford, the fields will never contain anything but digits, so it shouldn't be a problem then right?

I did some updates on my drawing and worksheet, here's how it looks now:

image.png.509170bdc8bbedb6943f140c8b5d2fbd.png

Here' a screenshot of my record format it might supply with some info. 

 

image.png.9a7b7d8edd451e8866081e12b2c87fa1.png

 

(I've used "Name" to connect with a data visualization, just so you know 😃

 

Thanks all! // Martin

Link to comment

Many thanks! I keep on going then 😃 New issue that I ran in to today.

How can I sum up the different values in this instance? 

 

image.png.5015a55b9e4a2ea36801c5247ebf0029.png

 

Every bench can hold 4 persons, the chairs can hold 1 person. I want to sum up the totals to make it easy for client to understand how many benches and chairs that are needed, and how much people will fit on each seating type. So when I do =B2*C2 I get the total amount (284*6) instead of 234*4. How can I do this for each row to make the Total sum correlate with each type of seating? I want a sum for 2.1, 2.2 and 2.3 separated.

 

Thank you for all your help!

 

martin 

Link to comment
  • 2 weeks later...
On 4/7/2023 at 5:18 PM, Pat Stanford said:

Did you ever get this working for your needs? If not can you post a sample file so I can take a look using your configuration.

Sorry, I just found out that I was logged out from this forum somehow and didn't get any notifications that I got a reply from you.

No, still in need of a solution for the thing above. Actually what I want is something like this:

Column A          Column B          Column C          Column D          

Setting type.      # of units.         # of ppl/unit.     Total of people

 

In Excel I just use the sum function in column D, but in VW I can't... Thanks!

Link to comment

You don't need a function, just a math operation. If your database header is in Row 3, then set the formula for Column D (cell D3) to:

 

=B3*C3

 

The same would work in Excel.

 

You are the second person who has come from Excel with the misunderstanding that you need the SUM function to do what is actually just a simple multiplication. Do you know why you learned to use SUM in excel? It makes sense for ranges of cells, but to just multiply one cell times another it seems overkill.

 

 

  • Like 2
Link to comment
On 4/21/2023 at 5:47 PM, Pat Stanford said:

You don't need a function, just a math operation. If your database header is in Row 3, then set the formula for Column D (cell D3) to:

 

=B3*C3

 

The same would work in Excel.

 

You are the second person who has come from Excel with the misunderstanding that you need the SUM function to do what is actually just a simple multiplication. Do you know why you learned to use SUM in excel? It makes sense for ranges of cells, but to just multiply one cell times another it seems overkill.

 

 

Thank you @Pat Stanford! Maybe I'm really stupid, but I can't get that to work. When I try to type in Column D, I can't. Not sure why. But, if I move down to Row 4 (or 5 and so on), it works. I want 228*4 in this case (Column B*Column C). 

 

Thank you again!

image.png.95ff46efff740d145a0704196eb8ad16.png

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

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

×
×
  • Create New...