count total month per year
 

Hi all,

I have a table like this

Name submit date
A 10-Jan-2006
B 13-Jan-2006
C 25-Feb-2006
A 5-Jul-2007
D 18-Aug-2007
C 23- Oct-2007

Questions:
1. how to count the total entries of each month per year and total entries
per year, ignoring the first column; so I will have Jan-2006=2 entries,
Feb-2006=1 entries; also 2006=3 entries, etc.
2. how to count and relate the two column; so I will have A on Jan-2006
submitted 2 entries etc.

Thank you so much for your help.

Brie

count total month per year
 

Use a pivot table and group the dates for months

http://peltiertech.com/Excel/Pivots/pivotstart.htm

http://www.contextures.com/xlPivot07.html

--

Regards,

Peo Sjoblom






"Brie" wrote in message
...
Hi all,

I have a table like this

Name submit date
A 10-Jan-2006
B 13-Jan-2006
C 25-Feb-2006
A 5-Jul-2007
D 18-Aug-2007
C 23- Oct-2007

Questions:
1. how to count the total entries of each month per year and total entries
per year, ignoring the first column; so I will have Jan-2006=2 entries,
Feb-2006=1 entries; also 2006=3 entries, etc.
2. how to count and relate the two column; so I will have A on Jan-2006
submitted 2 entries etc.

Thank you so much for your help.

Brie

count total month per year
 

Peo:

Thank you for this.

Took me some time to learn and test it. I had to squeeze my brain v hard :)
but finally I got it. Quite fun too!

Brie

"Peo Sjoblom" wrote:

Use a pivot table and group the dates for months

http://peltiertech.com/Excel/Pivots/pivotstart.htm

http://www.contextures.com/xlPivot07.html

--

Regards,

Peo Sjoblom






"Brie" wrote in message
...
Hi all,

I have a table like this

Name submit date
A 10-Jan-2006
B 13-Jan-2006
C 25-Feb-2006
A 5-Jul-2007
D 18-Aug-2007
C 23- Oct-2007

Questions:
1. how to count the total entries of each month per year and total entries
per year, ignoring the first column; so I will have Jan-2006=2 entries,
Feb-2006=1 entries; also 2006=3 entries, etc.
2. how to count and relate the two column; so I will have A on Jan-2006
submitted 2 entries etc.

Thank you so much for your help.

Brie