fuberator Posted December 31, 2020 Share Posted December 31, 2020 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 Quote Link to comment
Pat Stanford Posted December 31, 2020 Share Posted December 31, 2020 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 3 Quote Link to comment
fuberator Posted January 2, 2021 Author Share Posted January 2, 2021 thank you! Quote Link to comment
MartinBlomberg Posted May 4, 2022 Share Posted May 4, 2022 I can't really understand why they don't stick to the Excel standard, I need to google this all the time. 2 Quote Link to comment
fuberator Posted May 8, 2022 Author Share Posted May 8, 2022 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! Quote Link to comment
Pat Stanford Posted May 8, 2022 Share Posted May 8, 2022 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)? Quote Link to comment
fuberator Posted May 30, 2022 Author Share Posted May 30, 2022 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 1 Quote Link to comment
unearthed Posted May 31, 2022 Share Posted May 31, 2022 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. Quote Link to comment
Recommended Posts
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.