using excel 2010 need to count the number of dates a customer made contact over a year month by month can anyone help with a formula for this?
using excel 2010 need to count the number of dates a customer made contact over a year month by month can anyone help with a formula for this?
Your statement is vague, but have you tried a pivot table?
Would this help?
Copy of dates.xlsx see if this works for you. I just made a pivot table, and then on the dates I right clicked and selected Group By.
Here's a formula method.
Data Range
A B C D E F G H 1 Customer Date Customer Jan Feb Mar Apr 2 A 2/23/2013 A 0 1 0 1 3 A 4/10/2013 X 1 1 2 2 4 X 1/17/2013 Y 0 2 1 0 5 X 2/10/2013 Z 0 0 1 2 6 X 3/2/2013 7 X 3/10/2013 8 X 4/7/2013 9 X 4/30/2013 10 Y 2/6/2013 11 Y 2/28/2013 12 Y 3/29/2013 13 Z 3/15/2013 14 Z 4/1/2013 15 Z 4/10/2013
This formula entered in E2:
=SUMPRODUCT(--($A$2:$A$15=$D2),--(TEXT($B$2:$B$15,"mmm")=E$1))
Copy across then down as needed.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks