I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbSfreq

Sum values for given string/number combinations.

Example: (Newsgroup Microsoft.Public.Excel.Misc 23-Feb-2009 15:10).
I want to match the date of the expense
and get a monthly total seperate for business and personal, the date of the
expense and get a seperate yearly total for business and personal, the type
of expense and get seperate overall totals for business and personal, the
type of expense and get seperate totals for the type of payment seperated
into business and personal.

If you need a sorted output you can take my UDF sbGSort.

If you are interested in downloading a 46 KB Excel 2010 sample file (sbGSort.xlsm) go to my Download page, please.

sbSfreq_01_Screen
sbSfreq_01_Code
sbSfreq_02_Code

If you need to sum the last THREE columns (just one example of a possible derivative function):

sbS3freq_01_Code
sbS3freq_02_Code
Sulprobil   Get it done   Contact   Disclaimer   Download