View Single Post
 
Old 05-30-2017, 07:11 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

You can use a Pivot Table.

First, get the YEAR of each entry, in D2 enter formula: =YEAR(A2) copied down.

Then while you have one of the cells in the data selected go to Insert Menu and select Pivot Table. You can drag the Year and Company to the Row fields area and you can drag the % of Cash to the Summation area (to change to Sum instead of Count, click on Count of % of Cash, go to Value Field Settings and choose Sum.
Reply With Quote