Solution to Error: Aggregating Dividends that are listed individually...

Aggregating Dividends that are listed individually...

I have a list of dividends, some of them debits, some of them credits.
The list is broken down by sub-accounts.
I need the aggregate total of the Stock Position's dividend for a given date.
Here's what it looks like...

A B C D E
Date Account Stock #Shares
Dividend Amount
4/2/13 07010200 SPAN 9
-.01
4/2/13 07040012 BKCC -100
-26.00
4/2/13 07010200 BKYF 98
-.02
4/2/13 07010205 SPAN 100
-.07
4/2/13 07010200 OSM 58 -.01
4/2/13 07010206 SPAN 195
-.13
4/2/13 07010200 SPAN 9
-.01
4/2/13 07010205 SPAN 100
-.07

Basically what I need to do, is if there's multiple positions of the same stock symbol, I need them to be aggregated for each particular date, only showing a total amount of shares for that position (SPAN in this example), and showing a total amount of
the dividend.
So in this example, it would aggregate the SPAN position to 413 shares with the amount of -.29.
All the while, all of the symbols like BKCC, BKYF, and OSM, that don't have multiple entries will simply stay the same.
Please help me with this!!!!
It will make my life a lot easier!!! I appreciate your help in advance.
Thanks, Joel.

*******CLARIFICATION**********
I don't think I made it clear enough what outcome I am looking for.
I need a macro written that will bring about the following change to the above list...
Basically, I need to continue to see the list of stocks and their dividends, but if there are multiple
dividends for the same stock on the same date (in this example SPAN on 4/2), I need them to be aggregated into one position in the list.
The "answer" should look like this...

A  B  C  D  E
Date  Account  Stock  #Shares 
Dividend Amount
4/2/13  07010200  SPAN  413 
-.29
4/2/13  07040012  BKCC  -100 
-26.00
4/2/13  07010200  BKYF  98 
-.02
4/2/13  07010200 OSM  58 
-.01

Keys to the Problem Aggregating Dividends that are listed individually...

Download Error Fixer (Free)

This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Aggregating Dividends that are listed individually....

1. Back-up the Registry of your operating system.
2. Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
3. Note: this Registry Key should already exist, if it does not exist, create it.
4. Create a brand new DWORD Value that is named AllowOsUpdate
5. Set the Value to 0x00000001.
6. Close and reopen your Control Panel.
7. Restart the Microsoft Windows.

Recommended Method to Repair the Problem: Aggregating Dividends that are listed individually...:

How to Fix Aggregating Dividends that are listed individually... with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Related: ,[Solution] Error Clean,Solution to Error: mozilla thunderbird not responding windows 7,Fast Solution to Error: 0x00405da8,Troubleshoot:Toolbar,Solution to Problem: Windows Media Player C00d1199 Windows 7,Solution to Error: Windows 7Function,Troubleshooting:Pc Code 9999 Error,Solution to Problem: Norton Svchost Exe Virus,[Anwsered] Error 2738
Read More: Troubleshoot:After upgrading from Windows 7 Home to Windows 7 Pro, unable to connect to home network wirelessly,How to Resolve - Alfaclock2 won't start?,How to Fix Problem - all apps display same icon?,[Solution] After Oct 13 update, screen transitions are slow fades,[Solved] After upgrading to win 8.1 winpk filter error,32 bit printer drivers for Windows 7 64 bit OS,Activecell range 2 columns loop until last column,about pc battery power,Acrobat Reader downlode also automatically downloaded McAfee Security Plus...question about this below.,A runtime error has occurred. example: Line32 Do you wish to DeBug?