Sum Frequencies in VBA in Excel

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Sum Frequencies in VBA in Excel

FAQ

Thread Tools

Display Modes

04-30-2018, 08:16 AM

SailorJerry7030 SailorJerry7030 is offline

Windows 7 64bit Sum Frequencies in VBA in Excel

Office 2016

Novice

Join Date: Apr 2018

Posts: 7

SailorJerry7030 is on a distinguished road

Quote:

Originally Posted by Pecoflyer

Perhaps post a sample sheet with some data and expected results? ( Go advanced - Manage attachments)

No problem! Here is the test data. Test 1, Test 2, etc will be policy #'s and column Q is where I'd like the sum of the clusters to be placed. The Excel Code that ArviLaanemets provided works perfectly and gives the correct results in column S. However, I'm trying to use code in VBA to achieve these results as it will be for a larger data set.

Attached Images

sample.PNG (16.2 KB, 13 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data?	Hoser	Word	1	03-17-2017 03:47 PM
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open	kdash	Word	0	05-06-2015 09:38 AM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
[Excel 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
Excel 2011 can't open old Excel 98 or Excel X files	FLJohnson	Excel	8	05-09-2012 11:26 PM