Topic: summing range @ AskWoody

summing range
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » summing range
- This topic has 39 replies, 3 voices, and was last updated 15 years, 3 months ago.
Author

Topic
New Reply

WSsal21
AskWoody Lounger

January 14, 2010 at 2:20 am #465766

I have a range of cells filled with number from E8 to the last filled cell.
How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?

Reply | Quote

Viewing 30 reply threads
Author

Replies
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1199032
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1199776
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1200561
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1201442
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1202255
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1203059
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 2:20 am #1203950
  
  I have a range of cells filled with number from E8 to the last filled cell.
  How to summing in “one shot” the range of cells and store the result in a var as long with 2 decimal number?
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1198291
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1199098
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1199827
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1200591
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1201472
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1202285
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1203089
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 5:13 am #1203981
  
  Dim lVar As Long
  lVar = Round(Application.WorksheetFunction.Sum(Range(Range(“E8”), Range(“E” & ActiveSheet.Rows.Count).End(xlUp))), 2)
  
  Steve
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1198327
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1198333
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1199236
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1199881
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1200637
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1201514
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1202327
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1203131
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
  
  WSsal21
  AskWoody Lounger
  
  January 14, 2010 at 9:25 am #1204029
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  sorry…. Double, naturally.
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1199223
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1199875
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1200631
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1201508
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1202321
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1203125
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSrory
  AskWoody Lounger
  
  January 14, 2010 at 9:04 am #1204017
  
  Longs don’t have decimal places – they are integers. Did you mean Double?
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1198380
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1199459
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1199934
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1200690
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1201567
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1202380
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1203219
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
- WSsdckapr
  AskWoody Lounger
  
  January 14, 2010 at 1:07 pm #1204093
  
  Good catch. I read long and thought double….
  
  Steve
  
  Reply | Quote
Viewing 30 reply threads

Reply To: summing range
You can use BBCodes to format your content.
Your account can't use all available BBCodes, they will be stripped before saving.

Your information:
Name (required):

Mail (will not be published) (required):

Website:

Cancel

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

summing range

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Key Links

Remembering Woody

summing range

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Login and Registration

Key Links

Remembering Woody