Counting value that duplicate data

Closed
ndol - Nov 23, 2009 at 10:20 PM
 Blocked Profile - Nov 24, 2009 at 03:14 AM
Hello All,
I have trouble in VBA code that use for counting right cell that duplicate in left cell. Let i show you my data :
A 5000
B 1000
A 1500
B 2000
The count of A should be result 6500 then B is 3000. Anyone can help with VBA code for this case. Thanks b4.

1 response

Blocked Profile
Nov 24, 2009 at 03:14 AM
Dear Sir,

Please consider getting to the below address to have the solution

to the problem:

http://xldynamic.com/source/xld.SUMPRODUCT.html

Thanks in advance.
1