How to Sum an Array in VBA

In this episode, we're taking a look at how to sum up values in a VBA array. On this channel we have done some work with 1d and 2d arrays, mostly for speed in our applications. However, sometimes we need to do some math on our arrays and summing up all of the numbers in an array is high on the list for useful things to do when you're doing high-speed in-memory processing. We'll build an array of integers and then examine and sum up the values using two different methods, examining the benefits of each along the way. Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker: https://buy.billzone.com/bzrdpcloaker.html Check out my easy time entry system for your business: https://system.billzone.com/billzone Join me on Patreon! https://www.patreon.com/mackenziedataengineering Check out some tech (and support my channel!): https://www.amazon.ca/shop/seanmackenziedataengineering Want the code from this video? http://mackenziemackenzie.com/downloads Interested in transforming your career or finding your next gig? https://system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects.html Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #vba