Required VBA Codes to automate sum-up the 2 different groups

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Required VBA Codes to automate sum-up the 2 different groups

02-18-2014, 04:49 AM

macropod

Windows 7 32bit Required VBA Codes to automate sum-up the 2 different groups

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

You don't need VBA for that; you can do it with formulae:

Code:

In J4 =SUMPRODUCT((D:D=H4)*(RIGHT(B:B,1)<>"S"),F:F)
In K4 =SUMPRODUCT((D:D=H4)*(RIGHT(B:B,1)="S"),F:F)

Copy both formulae down to row 7

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Tabs and Groups	KHenry	Word	0	10-08-2013 09:37 AM
Bar Graph in Groups	Alaska1	Excel	3	12-17-2012 05:20 PM
Contacts List groups	WildBill	Outlook	1	09-21-2011 09:09 PM
Arranging Into Groups	skoz55	Excel	1	09-07-2011 12:02 AM
Some contacts are listed in groups I don't want	ironwoods	Outlook	0	07-29-2010 04:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:27 AM.