Aggregate Calls by Month

[excelmr]

I have a file containing list of products and calls. I am trying to aggregate products calls by Month.
May need VBA to accomplish the task. Any suggestion would be helpful.

File attached.

[DBY]

Hello

Not a VBA solution but if you wish to count TNK; ABL and HPS, then try the following formula:

=SUMPRODUCT(LEN($B$2:$B$16)-LEN(SUBSTITUTE($B$2:$B$16,D10,"")))/3

This gives 15; 6 and 3 respectively. D10 here contains the count criteria, TKN; ABL etc.

Hope this helps.
DBY

[MarvinP]

Hi excelmr,

I can get very close to the answer you want using Pivot Tables. See the formulas on sheet 1 to count the number of your 3 letter heads. I use these as "helper" columns before doing the pivot. Then in 2010 pivot tables you can show columns as a percentage of the other rows or columns. See https://www.youtube.com/watch?v=fFI9nV84pk4 for more on that.

See the attached for a close answer.